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.