/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

17 votes217 views4 answers
Postgres list users
SQL
4 votes260 views1 answer
Oracle change nls_date_format permanently
SQL
13 votes231 views3 answers
List all the tables in sql
SQL
10 votes257 views4 answers
Else if mysql
SQL
0 vote300 views1 answer
Mysql collation portugues brasil
SQL
10 votes248 views2 answers
What is database
SQL
0 vote209 views2 answers
How to create a table from another table in sql derby
SQL
0 vote222 views3 answers
Postgresql allow remote connections
SQL
0 vote286 views1 answer
Sql select rows between 1000 and 2000
SQL
3 votes208 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL