/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

4 votes302 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
3 votes319 views2 answers
Mysql update row
SQL
1 vote289 views2 answers
Mysql type conversion
SQL
0 vote307 views1 answer
Logtash mysql cofiguration file
SQL
0 vote331 views1 answer
Yesql
SQL
1 vote368 views1 answer
Postgresql can you have null foreign key
SQL
0 vote300 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote311 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote282 views1 answer
Soql more than today
SQL
1 vote296 views1 answer
Wordpress change url phpmyadmin
SQL