/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

10 votes227 views2 answers
Laravel collection toArray
PHP Laravel
0 vote210 views1 answer
Refresh web route laravel
PHP Laravel
5 votes212 views3 answers
Laravel model limit
PHP Laravel
18 votes226 views5 answers
If else statement in laravel blade
PHP Laravel
0 vote223 views1 answer
$request laravel undefined inside function query
PHP Laravel
0 vote221 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP Laravel
42 votes195 views6 answers
Laravel 8 foreign key
PHP Laravel
0 vote212 views1 answer
Call to a member function delete() on null laravel 8
PHP Laravel
19 votes215 views6 answers
Laravel logger
PHP Laravel
5 votes225 views3 answers
Crrate model in laravel
PHP Laravel

Share