/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 vote129 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote115 views1 answer
List in one column mysql
SQL
0 vote151 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote116 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote121 views5 answers
What is in operator in sql
SQL
0 vote130 views1 answer
Sql server information_schema temp tables
SQL
1 vote113 views1 answer
Mysql backup skip table
SQL
0 vote102 views1 answer
Sql check for null and empty string
SQL
0 vote114 views1 answer
Psql list view rules
SQL
0 vote121 views1 answer
HOW to select specific table data from an mysql databse server:
SQL