/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 vote190 views1 answer
Mysql page segment
SQL
0 vote184 views1 answer
Power query datetime to date
SQL
0 vote192 views1 answer
Sql search all columns of database oracle sql
SQL
8 votes181 views3 answers
Mysql alter table add index
SQL
-1 vote137 views3 answers
Ubuntu install mssql
SQL
0 vote189 views1 answer
Dapper run sql script with parameters
SQL
60 votes555 views6 answers
Add column in sql
SQL
0 vote152 views1 answer
Mysql timeout 30 seconds
SQL
0 vote221 views1 answer
Mysql last friday of current month
SQL
0 vote187 views2 answers
Sql trigger difference between for and after
SQL