/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 vote197 views1 answer
Sql server select rows by distinct column
SQL
1 vote209 views2 answers
Regex starts with
SQL
0 vote211 views1 answer
Primary key multiple colums
SQL
8 votes214 views1 answer
Oracle tablespace datafile max size
SQL
1 vote205 views1 answer
Oracle stop
SQL
2 votes218 views1 answer
Set auto increment from 1
SQL
1 vote203 views3 answers
Sql server get week dates from week number
SQL
28 votes206 views4 answers
Show tables mysql
SQL
13 votes217 views4 answers
Mysql remove foreign key constraint
SQL
1 vote192 views1 answer
Adding a default constraint to an existing column in sql
SQL