/PHP/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

6 votes385 views6 answers
Composer install laravel
PHP Laravel
16 votes349 views6 answers
Get first key of array php
PHP
2 votes376 views6 answers
Laravel get query parameters
PHP Laravel
16 votes322 views6 answers
Php console log
PHP
1 vote340 views1 answer
How to change laravel 8 login credentials
PHP Laravel
1 vote355 views1 answer
Convert Carbon Seconds Into Days Hours Minute
PHP
0 vote383 views1 answer
How to call function in blade laravel
PHP Laravel
5 votes317 views1 answer
What is the difference between static and dynamic websites?
PHP
0 vote302 views1 answer
How to add a clock in laravel
PHP
0 vote324 views1 answer
::update() should not be called statically
PHP

Share