/PHP/Laravel/Case inside laravel query

Case inside laravel query

Case inside laravel query

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

0

Source: stackoverflow.com

Similar codes

0 vote215 views1 answer
2 days left format in laravel
PHP Laravel
22 votes191 views5 answers
Update or insert in laravel
PHP Laravel
0 vote210 views1 answer
Laravel create coma separated string from query
PHP Laravel
0 vote225 views1 answer
Laravel display the date the participation was created
PHP Laravel
0 vote211 views2 answers
Timestamp in model laravel
PHP Laravel
35 votes253 views3 answers
Run seeder command in laravel
PHP Laravel
1 vote211 views1 answer
Insert data using model in laravel 8
PHP Laravel
1 vote219 views2 answers
Pass image path in laravel blade
PHP Laravel
0 vote1.9K views1 answer
Updateorinsert laravel for large data
PHP Laravel
3 votes216 views2 answers
Laravel eloquent search query 2020
PHP Laravel

Share