/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 vote352 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
0 vote301 views1 answer
Laravel controller constructor auth user null
PHP Laravel
0 vote282 views2 answers
Laravel download file from s3
PHP Laravel
4 votes351 views2 answers
Laravel attach
PHP Laravel
1 vote277 views1 answer
Laravel http retry
PHP Laravel
0 vote336 views2 answers
Laravel lumen
PHP Laravel
3 votes288 views4 answers
Delete multiple row by model in laravel
PHP Laravel
0 vote313 views1 answer
Laravel eloquent relationships count
PHP Laravel
1 vote364 views1 answer
How to calculate age in laravel
PHP Laravel
9 votes302 views3 answers
Laravel image validation
PHP Laravel

Share