/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 vote155 views1 answer
Sql contains vs like
SQL
0 vote177 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote115 views2 answers
Last working day in week date function in sql
SQL
1 vote160 views1 answer
Sysdate in sql
SQL
2 votes168 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote210 views1 answer
Mysql could not fetch tables
SQL
0 vote184 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote165 views2 answers
Check if word is in column sql
SQL
17 votes207 views6 answers
Get last record in sql
SQL
0 vote157 views1 answer
Create a PostgreSQL user django on mac
SQL