/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 vote181 views1 answer
Mysql update privileges
SQL
0 vote176 views1 answer
How much table store postgres
SQL
1 vote181 views1 answer
Select if then postgresql
SQL
0 vote185 views1 answer
How to write if case in select query in select statement
SQL
0 vote224 views1 answer
Mysql grant user wildcard database
SQL
1 vote259 views1 answer
Show databases mysql docker
SQL
1 vote187 views1 answer
Select tables with name like mysql
SQL
0 vote216 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote230 views1 answer
Delete from table where length sql
SQL
0 vote271 views1 answer
Contraint default SQL
SQL