In this article, we will see laravel 9 where condition example. Where condition is essential in each and every query in laravel. So, we will learn how to write multiple where conditions in laravel 9, and also we will see multiple columns in single where condition.
Where condition has three arguments, the first argument is the name of the column. The second argument is an operator. The third argument is the value to compare against the column's value.
So, let's see where conditions in laravel 9 and multiple where clauses in laravel 9.
Syntax of the where() condition.
In this example, we will retrieve the user's records using the operator. This query retrieves votes column equal to 80 and age is greater than 25.
$users = DB::table('users')
->where('votes', '=', 80)
->where('age', '>', 25)
->get();
if you want to verify that a column is =
to a given value, you may pass the value as the second argument to the where
method.
$users = DB::table('users')->where('votes', 80)->get();
In this example, you may pass the multiple arrays of conditions in the single where condition.
$users = DB::table('users')->where([
['status', '=', '1'],
['plan', '!=', '1'],
['closed', '=', false],
])->get();
In this example, you can use any operator that is supported by your database system.
$users = DB::table('users')
->where('votes', '>=', 80)
->get();
$users = DB::table('users')
->where('votes', '<>', 80)
->get();
$users = DB::table('users')
->where('name', 'like', 'web%')
->get();
In this example, we will retrieve records using the model.
$users = User::where('is_active','=', true)->get();
You might also like:
Hello Guys, Today I will give you example of laravel 8 REST API with passport authentication. Also perform...
May-31-2021
In the ever-evolving landscape of web development, crafting a tailor-made user authentication system stands as a pivotal...
Aug-25-2023
In this tutorial we will learn about laravel 8 inner join query example. Also see how to join two tables in laravel 8. I...
Nov-24-2021
Hello Freinds, In this tutorial we will see laravel 8 multiple database connections. Today I will give you step by st...
Apr-19-2021