/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 vote295 views1 answer
Update sql sintax
SQL
0 vote294 views1 answer
Sql missing values
SQL
0 vote264 views1 answer
Order by ip address sql
SQL
8 votes418 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote279 views1 answer
Sql tablo hangi sp de
SQL
0 vote271 views1 answer
Oracle c# multiple update sql
SQL
10 votes259 views3 answers
Insert into auto increment mysql
SQL
1 vote257 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote251 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote273 views1 answer
Cannot start database server xampp mac os
SQL