/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 vote281 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel
0 vote225 views1 answer
Laravel how to query belongsTo relationship
PHP Laravel
0 vote264 views1 answer
Laravel blade get array count in Blade
PHP Laravel
0 vote238 views1 answer
Stdclass not found laravel
PHP Laravel
0 vote260 views1 answer
Laravel get all vendor files
PHP Laravel
0 vote259 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
3 votes248 views2 answers
How to change laravel port
PHP Laravel
0 vote246 views1 answer
Flexslider in laravel 5.8
PHP Laravel
1 vote253 views1 answer
Run jobs laravel
PHP Laravel
2 votes240 views1 answer
Laravel's collection pagination
PHP Laravel

Share