/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 vote272 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote199 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote236 views1 answer
Sql grant select only
SQL
1 vote228 views1 answer
Limit offset order by mysql
SQL
12 votes195 views3 answers
Duplicate a column in sql
SQL
0 vote252 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
19 votes206 views5 answers
Change column name mysql command line
SQL
1 vote217 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote196 views1 answer
Android sqlite get rows count
SQL
2 votes234 views1 answer
Express api ith mysql data
SQL