/PHP/Laravel/Laravel eloquent select case when

Laravel eloquent select case when

Case inside laravel query

DB::table('ref')->select(['id','name',DB::raw('(case when (id > 17) then "yes" else "no" end) as present')])->get();

Source: stackoverflow.com

Laravel eloquent select case when

->select('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',
  DB::raw('(CASE WHEN users.id = ' . $user . ' THEN 1 ELSE 0 END) AS is_user')
  )

Similar codes

4 votes333 views3 answers
Laravel view routes
PHP Laravel
18 votes327 views6 answers
Redirect to route laravel
PHP Laravel
46 votes387 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
1 vote342 views1 answer
Publishing laravel module package
PHP Laravel
0 vote347 views1 answer
Laravel eloquent update quantity
PHP Laravel
0 vote318 views1 answer
Make() laravel
PHP Laravel
1 vote337 views1 answer
Laravel date diff
PHP Laravel
2 votes284 views1 answer
Laravel slug route
PHP Laravel
-1 vote333 views4 answers
Laravel create command tutorial
PHP Laravel
0 vote349 views2 answers
Option value selected in laravel blade
PHP Laravel