ItSolutionStuff.com

We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel. If you want to use mysql function then you must have to use db raw function. in this example i will show you laravel select query with if condition.

In minor case we need to use if else condition in laravel 5, laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 Eloquent. It might be use when you just need to send data to import or api etc.

I will give you example when you can use this kind of when case statement in mysql query. If you take "status" fields in users table with following meaning:

0 => User

1 => Admin

2 => SuperAdmin

So at this time we store 0 1 or 2 values in database table but when we select at that time it should become "User" "Admin" and "SuperAdmin".

We can write mysql query like this way:

SELECT '(CASE 
            WHEN users.status = "0" THEN "User" 
            WHEN users.status = "1" THEN "Admin"
            ELSE "SuperAdmin" 
            END) AS status_lable'
FROM users

But you can write this query in Laravel like this way:

$users = User::select("*",
                    \DB::raw('(CASE 
                        WHEN users.status = "0" THEN "User" 
                        WHEN users.status = "1" THEN "Admin" 
                        ELSE "SuperAdmin" 
                        END) AS status_lable'))
                ->get();
   
dd($users);

I hope it can help you....