/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 vote102 views1 answer
Set column in all row mysql
SQL
1 vote101 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
15 votes99 views2 answers
Install mysql 8 ubuntu 18.04
SQL
6 votes102 views1 answer
Oracle trigger after logon on schema
SQL
0 vote142 views1 answer
Cahnge column name apex oracle
SQL
1 vote101 views1 answer
Mysql query where in select
SQL
1 vote91 views2 answers
DROP TABLes regardless of constraints
SQL
4 votes109 views1 answer
Mysql biginteger size
SQL
-1 vote119 views1 answer
Adding a new table psql
SQL
-1 vote102 views1 answer
How to check table exists or not in postgresql
SQL