/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 vote355 views1 answer
Laravel apache public folder
PHP Laravel
3 votes389 views1 answer
Laravel eloquent get column
PHP Laravel
2 votes301 views1 answer
Laravel delete route
PHP Laravel
1 vote425 views1 answer
How to add property to the request object in laravel
PHP Laravel
0 vote367 views1 answer
Laravel move/rename file ftp
PHP Laravel
15 votes330 views3 answers
Laravel setup auth
PHP Laravel
62 votes427 views6 answers
Clear cache laravel
PHP Laravel
3 votes360 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
8 votes364 views6 answers
Define table name in model laravel
PHP Laravel
0 vote324 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel

Share