/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 vote177 views1 answer
Console output pl sql
SQL
0 vote239 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
3 votes198 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
38 votes264 views4 answers
Count sql
SQL
0 vote280 views3 answers
Get count of null in column sql
SQL
1 vote210 views1 answer
Sql and
SQL
0 vote198 views1 answer
Power bi union columns
SQL
0 vote189 views1 answer
Porcentaje sql
SQL
0 vote234 views1 answer
Sql tablo sp
SQL
0 vote186 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL