/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

3 votes349 views1 answer
Uppercase and lowercase in sql
SQL
1 vote321 views10 answers
Stack overflow
SQL
0 vote333 views1 answer
Sub query in linq
SQL
1 vote351 views3 answers
Showing all columns in an sqlite table
SQL
1 vote326 views4 answers
Between vs in sql
SQL
-1 vote379 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote333 views1 answer
Mysql filter based on datediff
SQL
3 votes343 views1 answer
Créer une table sql
SQL
0 vote331 views1 answer
Joins vs includes
SQL
1 vote338 views1 answer
Postgresql blocked on mac
SQL