/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 vote117 views1 answer
Rename table column name in mysql
SQL
1 vote112 views1 answer
Sql auto date
SQL
1 vote125 views2 answers
Oracle difference between two dates in seconds
SQL
1 vote118 views1 answer
Snowflake rename column name
SQL
11 votes116 views2 answers
MySQL DISTINCT
SQL
0 vote114 views1 answer
Uncomment listen_address=localhost
SQL
0 vote113 views1 answer
Minus equivalent in my sql
SQL
1 vote110 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote114 views1 answer
Oracle query to see what scema i am working in
SQL
7 votes124 views4 answers
Database dump mysql command
SQL