/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

5 votes243 views3 answers
Mysql check if null or empty string
SQL
5 votes268 views2 answers
Mysql import gzip db
SQL
0 vote246 views1 answer
A network or instance-specific error sql server
SQL
5 votes245 views1 answer
Oracle ora-00054 causes
SQL
0 vote257 views1 answer
Mssql view column data type
SQL
-2 votes261 views1 answer
Group functions in sql
SQL
0 vote250 views1 answer
Postgresql update to unique
SQL
13 votes267 views2 answers
Get date from now() mysql
SQL
9 votes279 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote246 views1 answer
Forcefully delete a row in mysql which has references
SQL