/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

3 votes256 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote264 views1 answer
PSQL qith variables
SQL
7 votes284 views1 answer
Query postgres delete duplicates
SQL
-1 vote261 views1 answer
Mysql extract days
SQL
0 vote255 views1 answer
How to find database collation in postgres
SQL
0 vote254 views1 answer
Create table if not exist with exceptions
SQL
0 vote268 views1 answer
Get from database the most recent data limit by 5
SQL
6 votes274 views1 answer
Oracle list primary key
SQL
0 vote260 views1 answer
Mysqldump ignore table
SQL
0 vote285 views2 answers
How to take recent row without limit in mysql
SQL