/SQL/Use cases condition in sql query laravel

Use cases condition in sql query laravel

->selectRaw("shares.id AS share_id, users.id AS user_id , 
    shares.connected_user_id ,    
      shares.original_language_id, shares.image,
      users.first_name, users.last_name, users.email,
      locations.city, provinces.name, countries.code,
      locations.lat, locations.lng,
      shares.created_at,
      (CASE WHEN users.id = {$user} THEN 1 ELSE 0 END) AS is_user)")
    ->orderBy('shares.created_at', 'desc')

Similar codes

1 vote143 views1 answer
How refresh navicat tables to see new tables
SQL
8 votes178 views2 answers
How to fetch data from database without last column
SQL
0 vote163 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote258 views1 answer
Mssql unique key accept nulls
SQL
0 vote162 views4 answers
How to drop all tables in sql
SQL
0 vote160 views1 answer
Sql recherche nom prenom
SQL
1 vote285 views1 answer
Postgres set column based on another column
SQL
3 votes149 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote171 views1 answer
Mariadb create index if not exists
SQL
7 votes146 views6 answers
Reset identity column in sql server
SQL