/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

0 vote257 views1 answer
Get all employees if name ends with in sql
SQL
0 vote283 views1 answer
Mysql join only one column
SQL
0 vote293 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote270 views1 answer
Import in mysql without a software
SQL
0 vote275 views1 answer
Renombrar tabla mysql
SQL
0 vote322 views1 answer
Postgres list all triggers
SQL
0 vote277 views1 answer
Insert array into mysql column
SQL
-1 vote289 views1 answer
How to dump .csv file into mysql
SQL
3 votes325 views1 answer
Mysql group_concat distinct
SQL
17 votes307 views4 answers
Show tables sql server
SQL