/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

18 votes378 views3 answers
Mysql add column default value
SQL
0 vote346 views1 answer
Php delete database
SQL
0 vote399 views1 answer
Mariadb create index if not exists
SQL
4 votes336 views2 answers
DB::transaction
SQL
1 vote356 views1 answer
Postgres get month name from date
SQL
23 votes393 views6 answers
Create table sql server
SQL
0 vote337 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote376 views1 answer
How to get the date diff on once field in sql server
SQL
3 votes359 views1 answer
Set default today mysql
SQL
0 vote374 views1 answer
How do I insert a blob in SQL?
SQL