/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 vote152 views1 answer
Redshift running queries
SQL
0 vote134 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote134 views1 answer
Postgresql parse json array
SQL
0 vote152 views3 answers
Sql parenthetical expression examples
SQL
0 vote142 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote146 views1 answer
Oracle sql add column auto generated value
SQL
0 vote127 views1 answer
Tsql generate rows
SQL
0 vote172 views1 answer
Mysql get hour from datetime
SQL
0 vote140 views1 answer
Postgres 11 add primary key
SQL
1 vote144 views1 answer
Postgresql contains
SQL