/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

4 votes119 views2 answers
Mysql delete user if exists
SQL
1 vote117 views1 answer
Sql not equal multiple columns
SQL
-1 vote124 views1 answer
How to open blade file from blade in laravel
SQL
0 vote147 views2 answers
Suse stop MySQL
SQL
0 vote133 views1 answer
Mysql local password denied
SQL
0 vote133 views1 answer
Mysql page segment
SQL
0 vote125 views1 answer
Sql server express download
SQL
4 votes120 views2 answers
Select first and last row mysql
SQL
0 vote116 views1 answer
Sqlite3 now
SQL
0 vote131 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL