/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 vote170 views2 answers
DROP TABLes regardless of constraints
SQL
5 votes157 views3 answers
How to remove unique key constraint in mysql
SQL
3 votes172 views2 answers
How to start postgresql on windows
SQL
0 vote188 views1 answer
Create boolean column in MySQL with false as default value?
SQL
3 votes168 views2 answers
Find the median in sql
SQL
1 vote167 views1 answer
Postgresql filter on
SQL
-1 vote174 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote173 views1 answer
Mysql list bigger table
SQL
0 vote160 views1 answer
Inser into example
SQL
0 vote121 views1 answer
Get last run query sql server
SQL