/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
Create table as select sql server error
SQL
0 vote293 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote291 views1 answer
Interview experience as a call?
SQL
1 vote306 views1 answer
Mysql connect bash
SQL
0 vote277 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote273 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote312 views1 answer
Alter constraint in sql
SQL
1 vote319 views1 answer
Show databases mysql docker
SQL
2 votes285 views2 answers
How to DROP a table in mysql
SQL
0 vote295 views4 answers
Mysql count table rows
SQL