/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 vote437 views1 answer
Postgresql powershell query
SQL
0 vote329 views1 answer
What does leave do in mysql
SQL
0 vote323 views1 answer
Openquery insert into linked server
SQL
0 vote339 views1 answer
Insert into table with only identity column
SQL
8 votes316 views1 answer
Oracle add months to sysdate
SQL
3 votes309 views1 answer
Oracle user quota on tablespace
SQL
1 vote325 views1 answer
Oracle drop job if exists
SQL
23 votes332 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote330 views1 answer
Insert or update sql firebird
SQL
3 votes304 views1 answer
Oracle undo tablespace list by user
SQL