LaravelLaravel 5.8

How to use case in Laravel query?


Hello to all, welcome to 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,
             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

Ajay Malhotra
the authorAjay Malhotra
Hello to all. Welcome to Myself Ajay Malhotra and I am full stack developer. I love coding. I know Wordpress, Core php, Angularjs, Angular 2, Angular 6, Angular 7, laravel, Codeigniter, Shopify, Squarespace, Jquery, Google Map Api, Vuejs, Reactjs, Bigcommerce etc.

Leave a Reply

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

Positive SSL