/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

1 vote290 views1 answer
Mysql pretty date format
SQL
1 vote317 views1 answer
Psql search table
SQL
0 vote300 views2 answers
How to relationship query two different tables in MySQL
SQL
2 votes297 views3 answers
3 days back in sql server
SQL
0 vote302 views1 answer
Learn sqlite dart
SQL
0 vote309 views1 answer
Mysql regex select
SQL
0 vote316 views1 answer
Mysql query to select the highest value
SQL
1 vote325 views3 answers
Alter schema sql server
SQL
3 votes327 views3 answers
Raw select laravel
SQL
0 vote314 views1 answer
Postgres create extension if not exists
SQL