/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 vote65 views1 answer
Sqlalchemy existing database
SQL
16 votes112 views3 answers
Update table from another table
SQL
1 vote93 views1 answer
Mysql query bulk insert
SQL
27 votes118 views6 answers
Set password mysql
SQL
0 vote109 views1 answer
Manage Database in MySQL
SQL
0 vote121 views1 answer
Sql server is not
SQL
5 votes104 views1 answer
Sort order on two columns sql
SQL
3 votes96 views2 answers
Sql paging query
SQL
13 votes95 views2 answers
Sqlite rename column
SQL
0 vote109 views1 answer
Oracle calculate statistics on partition
SQL