/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 vote190 views1 answer
Hangfire clean script
SQL
0 vote255 views1 answer
List in one column mysql
SQL
0 vote234 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote193 views1 answer
Get last run query sql server
SQL
1 vote245 views1 answer
Spring postgresql reset auto increment to 0
SQL
22 votes252 views3 answers
Remove all records from table mysql
SQL
9 votes241 views2 answers
Sql server check table exists
SQL
4 votes219 views2 answers
How to delete row in sql
SQL
0 vote240 views1 answer
Search starting with mysql
SQL
2 votes281 views1 answer
Python sql
SQL