/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 vote175 views1 answer
Remove binlog mysql
SQL
0 vote193 views1 answer
Sql server get date of previous sunday
SQL
1 vote168 views1 answer
How to get alternate records from a table in sql
SQL
0 vote178 views1 answer
Postgres jsonb array push new element
SQL
0 vote175 views1 answer
Top 3 salary in sql
SQL
2 votes200 views1 answer
Revokeprivileges mysql
SQL
0 vote177 views1 answer
Sql select lowest value row
SQL
0 vote173 views1 answer
Cannot start database server xampp mac os
SQL
0 vote198 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote187 views1 answer
Mysql Like(searching in the string)
SQL