/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

15 votes313 views4 answers
Laravel session flash 2020
PHP Laravel
10 votes289 views4 answers
Import session laravel
PHP Laravel
0 vote335 views1 answer
Bu7scador con laravel
PHP Laravel
12 votes346 views6 answers
Laravel json response
PHP Laravel
2 votes314 views1 answer
Get user ip laravel
PHP Laravel
1 vote331 views1 answer
Laravel group by created_at date only
PHP Laravel
1 vote316 views2 answers
Get unique values in laravel
PHP Laravel
10 votes322 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
0 vote369 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
2 votes298 views4 answers
Laravel redirect action
PHP Laravel

Share