/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

1 vote141 views1 answer
How to insert multiple data at a time with create method in laravel
PHP Laravel
0 vote137 views1 answer
Laravel npm run deve error mix
PHP Laravel
1 vote136 views2 answers
Laravel has many with ids
PHP Laravel
0 vote154 views1 answer
Laravel collection reject
PHP Laravel
0 vote155 views1 answer
Validate file count with validate in laravel
PHP Laravel
1 vote139 views1 answer
Cart::total return number format value laravel
PHP Laravel
6 votes151 views2 answers
Laravel 6 get user id
PHP Laravel
0 vote158 views1 answer
How to remove updated_at or use only created_at laravel eloquent ORM
PHP Laravel
2 votes128 views4 answers
Laravel where in array
PHP Laravel
44 votes192 views6 answers
Laravel migrate seed
PHP Laravel

Share