/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 vote164 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote128 views3 answers
Java hide mysql login credentials
SQL
0 vote143 views1 answer
Template MySQL Zabbix agent
SQL
0 vote116 views2 answers
Get top 1 row of each group
SQL
1 vote120 views1 answer
Create table tablename as select * from tablename
SQL
0 vote146 views1 answer
PSQL use LIKE with timestamps
SQL
3 votes185 views2 answers
Mysql user permission database
SQL
0 vote122 views1 answer
Enable outgoing remote MySQL access
SQL
7 votes128 views2 answers
Phpmyadmin change password
SQL
0 vote132 views1 answer
UNION ALL LEFT JOIN
SQL