/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 vote163 views1 answer
Print year of a date sql
SQL
1 vote133 views1 answer
Store select query result in variable sql server
SQL
4 votes145 views1 answer
Id increment ms sql server
SQL
0 vote172 views1 answer
Tsql cte in a transaction
SQL
0 vote166 views1 answer
Sql anywhere create procedure
SQL
0 vote125 views1 answer
Metada in sql
SQL
0 vote134 views1 answer
Netstat -tln mysql
SQL
16 votes145 views1 answer
CTE statement sql server
SQL
0 vote144 views1 answer
Mysql set boolean default value
SQL
1 vote163 views1 answer
Mysql return text after a final full stop
SQL