/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

1 vote143 views2 answers
Oracle replace
SQL
4 votes135 views3 answers
Sql find second highest salary employee
SQL
0 vote139 views1 answer
Convert sql server guid to varbinary
SQL
6 votes157 views2 answers
Mysql timestamp to date
SQL
0 vote148 views1 answer
Psql store procedure-return multiple table values
SQL
26 votes141 views2 answers
What is the sql statement that finds duplicate usernames
SQL
19 votes172 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote142 views1 answer
Delete data from database sqlite android
SQL
0 vote153 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote149 views1 answer
Sql list dates between two dates
SQL