How to use case in Laravel query?

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