/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 vote251 views1 answer
Sql server remove primary key without dropping table
SQL
3 votes189 views1 answer
Index using in query plsql
SQL
0 vote241 views1 answer
Original Query
SQL
1 vote174 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote198 views2 answers
Insert sqlite
SQL
3 votes205 views2 answers
Sqlite print all column names
SQL
2 votes199 views2 answers
Sqlite_busy: database is locked
SQL
1 vote193 views1 answer
How to unlock table in mysql
SQL
0 vote187 views2 answers
Select a row include list of array with join two table SQL
SQL
3 votes237 views1 answer
How to uninstall microsoft sql server
SQL