Categories

Wednesday, July 10, 2024
#919814419350 therichposts@gmail.com
LaravelLaravel 5.8

How to use case in Laravel query?

Laravel 7.2 routing with route group auth guard check with prefix

Hello to all, welcome to therichpost.com. In this post, I will tell you, How to use case in Laravel query?

Laravel is the top PHP MVC framework and today, I am just telling you simple code snippet for Case Statement in Laravel Query.

use DB;
$employee = "SELECT firstName,
             CASE
             WHEN status = 2 THEN 'Completed'
             WHEN status = 3 THEN 'Cancelled'
             WHEN status = 4 THEN 'Cancelled'
             FROM employee";
$employeedata = DB::select( DB::raw(  $employee  ) );

 

If you have query related to this post, then please do comment below.

Jassa Jatt,

Thank you

therichpost
the authortherichpost
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 14, Angular 15, Angular 16, Angular 17, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.