/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 vote366 views2 answers
Suse stop MySQL
SQL
0 vote353 views1 answer
Vowels in sql
SQL
0 vote358 views2 answers
Starts and end with vowel sql
SQL
0 vote386 views2 answers
List all constraints in postgres
SQL
2 votes349 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote390 views1 answer
How to check rollback status in oracle
SQL
40 votes448 views4 answers
PostgreSQL add column
SQL
0 vote340 views2 answers
Postgresql get last day of month
SQL
0 vote320 views1 answer
Oracle last connection
SQL
10 votes369 views2 answers
Mysql drop database if exists
SQL