/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

10 votes197 views2 answers
Sql rtrim
SQL
1 vote224 views1 answer
Mysql select and count left join
SQL
3 votes210 views2 answers
See mysql users ubuntu
SQL
1 vote185 views3 answers
Grant syntax in sql
SQL
0 vote180 views1 answer
Is numeric in sql
SQL
-1 vote203 views1 answer
Count occurrences sql
SQL
0 vote197 views1 answer
Mssql disable foreign key constraint
SQL
2 votes321 views1 answer
Mysql create user with remote access
SQL
0 vote217 views1 answer
Mysql sleep connections
SQL
0 vote197 views2 answers
Null value in column violates not-null constraint
SQL