/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

1 vote77 views1 answer
Convert epoch to date in sql server
SQL
0 vote63 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote72 views1 answer
Renombrar tabla mysql
SQL
8 votes75 views1 answer
Check mysql version phpmyadmin
SQL
0 vote67 views4 answers
Change schema in sql server
SQL
0 vote72 views1 answer
Mysql workbench procedure
SQL
0 vote78 views1 answer
Pgadmin save data greyed out
SQL
150 votes197 views10 answers
Grepper
SQL
1 vote79 views2 answers
How to drop a unique constraint in sql
SQL
1 vote66 views1 answer
Mysql show table character set
SQL