/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 vote124 views3 answers
Drop multiple columns in sql
SQL
1 vote108 views1 answer
Oracle show execution plan
SQL
1 vote125 views1 answer
Decalre temp table sql
SQL
2 votes125 views2 answers
Sql query to copy data from one column to another
SQL
0 vote107 views1 answer
Alter table add foreign key mariadb example
SQL
8 votes120 views2 answers
Sqlsrv default port
SQL
1 vote132 views1 answer
Oracle drop job if exists
SQL
0 vote115 views1 answer
Can we rollback deleted data in sql
SQL
1 vote336 views1 answer
How to make a select in sql
SQL
0 vote110 views1 answer
Oracle last character of string
SQL