/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 vote151 views1 answer
Sql server count all tables rows
SQL
0 vote197 views2 answers
Search stored procedures by name
SQL
0 vote144 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote152 views2 answers
Sql auto update dupdated_at
SQL
0 vote168 views1 answer
How to open mysql in docker
SQL
0 vote180 views1 answer
How to change the field size of an existing column
SQL
0 vote180 views2 answers
Uninstall postgresql mac
SQL
1 vote229 views1 answer
Python clean sql string
SQL
2 votes189 views1 answer
Mariadb json select
SQL
0 vote161 views1 answer
Sql change column in existing table
SQL