/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

6 votes365 views2 answers
Psql load dump
SQL
0 vote383 views1 answer
Psql get table data types
SQL
0 vote381 views1 answer
How to make case insensitive in sql
SQL
12 votes444 views6 answers
Change mysql root password
SQL
1 vote345 views1 answer
Base nosql
SQL
0 vote336 views1 answer
Sqldf change user
SQL
0 vote356 views1 answer
Sauvegarde complète my sql
SQL
3 votes340 views1 answer
How to check schema privileges in oracle
SQL
0 vote411 views1 answer
Update top 100 order by sql server
SQL
0 vote344 views1 answer
Mysql terminal list table
SQL