/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

2 votes181 views1 answer
Datefromparts mssql
SQL
10 votes150 views2 answers
Forgot my mysql password mac
SQL
1 vote141 views2 answers
Update with inner join sql server
SQL
0 vote144 views2 answers
Script all indexes in a database
SQL
0 vote156 views1 answer
Safe mysql
SQL
0 vote155 views1 answer
Remove transient options sql wordpress
SQL
3 votes149 views2 answers
Order by postgresql
SQL
1 vote142 views1 answer
Operator does not exist: integer = text
SQL
0 vote145 views1 answer
Laravel eloquent get generated sql
SQL
0 vote157 views1 answer
How to map sql column to custom names
SQL