In this article, we will see the laravel 9 and laravel 10 multiple where condition query example. We will learn how to write multiple where clauses in the laravel 9 query builder. Also, we will use the where() function in laravel 9/10. Sometimes we need multiple conditions in the query.
So, we will give you how to create multiple where clause queries using laravel 9 eloquent. Also, you can use this multiple where condition in laravel 8, laravel 9, and laravel 10.
The most basic call to the where
method requires three arguments. The first argument is the name of the column. The second argument is an operator, which can be any of the database's supported operators.
So, let's multiple where conditions in laravel 9 and laravel 9 where conditions.
Syntax of multiple where condition.
->where('COLUMN_NAME', 'OPERATOR', 'VALUE')
->where('COLUMN_NAME', 'OPERATOR', 'VALUE')
Also, you can write on single where condition.
->where([
['COLUMN_NAME', 'OPERATOR', 'VALUE'],
['COLUMN_NAME', 'OPERATOR', 'VALUE']
]);
SQL query with multiple where conditions.
SELECT * FROM `users`
WHERE votes = 100 AND votes > 35;
For example, the following query retrieves users where the value of the votes
column is equal to 100
and the value of the age
column is greater than 35.
Example 1:
$users = DB::table('users')
->where('votes', '=', 100)
->where('age', '>', 35)
->get();
Example 2:
$users = DB::table('users')
->where([
['votes', '=', 100],
['votes', '>', 35]
])
->get();
Conditions using Array:
$users = User::where([
'column1' => value1,
'column2' => value2,
'column3' => value3
])->get();
This query like produced below:
SELECT * FROM TABLE WHERE column1 = value1 and column2 = value2 and column3 = value3
You might also like :
Creating an auto-generating slug using Laravel Livewire is a practical and efficient way to handle slugs for your applic...
Oct-27-2023
Hey there, Laravel enthusiasts! If you're looking to add a touch of elegance and user-friendliness to your web...
Feb-14-2024
In this article, we will see multi step form wizard jquery validation. Here, we will learn jquery validation for mu...
Jan-30-2023
Hey folks, are you ready to make your Laravel Vue.js application even more user-friendly by implementing validation erro...
Mar-08-2024