/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

5 votes356 views1 answer
Oracle nls session
SQL
0 vote321 views1 answer
Laravel eloquent get generated sql
SQL
1 vote340 views3 answers
Execute sp in sql server
SQL
0 vote376 views1 answer
Move table to a different schema
SQL
0 vote303 views1 answer
Dump only schema
SQL
14 votes311 views2 answers
Sql cast
SQL
12 votes337 views2 answers
Update column data type postgres
SQL
8 votes334 views4 answers
How to calculate the age from date of birth in python
SQL
3 votes345 views1 answer
Oracle failed login attempts
SQL
0 vote321 views1 answer
Mysql regex exact match
SQL