/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

0 vote214 views1 answer
Php/Laravel check if date is passed
PHP Laravel
0 vote216 views1 answer
Get am pm 12 hour timee laravel
PHP Laravel
0 vote240 views1 answer
Laravel enable mysql logging
PHP Laravel
2 votes213 views1 answer
Laravel upload image to public folder
PHP Laravel
1 vote299 views3 answers
Queue jobs in laravel
PHP Laravel
1 vote217 views1 answer
String to uppercase laravel
PHP Laravel
0 vote213 views1 answer
Laravel resource set status code
PHP Laravel
3 votes207 views2 answers
Laravel where condition on relationship
PHP Laravel
47 votes280 views6 answers
How to run specific seeder in laravel
PHP Laravel
16 votes228 views6 answers
Session laravel
PHP Laravel