/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 vote348 views2 answers
How to count codition
SQL
0 vote342 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote336 views1 answer
Cross apply top for each row t1
SQL
49 votes372 views6 answers
Get duplicate records in sql
SQL
0 vote355 views1 answer
Sql script to remove default from column
SQL
3 votes330 views2 answers
How to load files in mysql
SQL
6 votes315 views2 answers
WHERE value IS sql
SQL
0 vote312 views1 answer
Get who is hired in january in sql
SQL
2 votes336 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote333 views1 answer
How to set sql_mode for a query in CI model
SQL