/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 vote227 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote210 views1 answer
Sub blocks in sql
SQL
0 vote220 views1 answer
Postgres type equivalent to timespan c#
SQL
11 votes208 views2 answers
Mysql disable safe mode
SQL
1 vote211 views1 answer
Create procedure with encryption
SQL
0 vote231 views1 answer
WHERE not regex in SQL
SQL
0 vote179 views1 answer
Delete all rows from table sqlite
SQL
0 vote218 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote242 views1 answer
Hour and minute between two datatime sql
SQL
0 vote210 views1 answer
Sql select all records from all tables where not empty
SQL