/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

10 votes206 views4 answers
Drop primary key
SQL
5 votes196 views1 answer
Oracle asynchronous update
SQL
0 vote192 views1 answer
Set default value now() date
SQL
1 vote179 views1 answer
Apex run 404
SQL
4 votes213 views2 answers
Dbms output
SQL
0 vote195 views1 answer
Mysql workbench not showing schemas
SQL
3 votes185 views1 answer
Sql cast to integer
SQL
0 vote205 views1 answer
Sql datediff db2
SQL
0 vote204 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote209 views2 answers
Check if word is in column sql
SQL