/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 votes246 views2 answers
Postgresql get table names
SQL
0 vote236 views1 answer
Normalization in database 2nd normal form
SQL
0 vote180 views1 answer
Mysql insert with foreign key
SQL
1 vote215 views2 answers
Limit sqlserver
SQL
1 vote234 views1 answer
Query for all indexes in table postgres
SQL
6 votes620 views3 answers
Sql select last id
SQL
1 vote189 views1 answer
Full text index mysql
SQL
20 votes223 views4 answers
Sqlite create table if not exists
SQL
3 votes238 views2 answers
Truncate all tables
SQL
0 vote230 views1 answer
Connecting mySQL to STS
SQL