/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

3 votes170 views5 answers
Mysql get last inserted id
SQL
0 vote174 views1 answer
Soql queries for not contact related account records in salesforce
SQL
16 votes167 views2 answers
Mysql date between two dates
SQL
0 vote252 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
15 votes326 views2 answers
Sql order by alphabetical
SQL
0 vote151 views1 answer
Postgresql certain first 4 characters in string
SQL
7 votes177 views3 answers
Sql set
SQL
0 vote165 views1 answer
Char vs varchar2 in sql
SQL
24 votes168 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
1 vote182 views1 answer
Change table to innodb mysql
SQL