Laravel orWhere Condition using Eloquent Query
Today's topic is how to use or where condition in laravel eloquent. How works laravel orWhere() query. i will give you simple example of or where condition in laravel query builder. you can use laravel eloquent or where easily.
you can simple use orWhere eloquent method in laravel 6, laravel 7, laravel 8, laravel 9 and laravel 10.
If you need to use sql or where query in laravel then you can use it. Laravel provide orWhere() to use sql or query query. in or where() we just need to pass two argument one is column name and will be value.
You can see bellow syntax on orWhere query in laravel:
orWhere(Coulumn_name, Value);
Now i will give you three example of how to use orWhere query in laravel application. So let's see those example how it works.
Example 1:
SQL Query:
SELECT *
FROM users
WHERE id = '23' OR email = 'itsolutionstuff@gmail.com'
Laravel Query:
public function index()
{
$users = DB::table('users')
->where('id', 23)
->orWhere('email', 'itsolutionstuff@gmail.com')
->get();
dd($users);
}
Example 2:
Here is another example of how it works with model. you can work as like bellow:
public function index()
{
$users = User::select("*")
->where('id', 23)
->orWhere('email', 'itsolutionstuff@gmail.com')
->get();
dd($users);
}
I hope it can help you...

Hardik Savani
I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Laravel, Angular, Vue, Node, Javascript, JQuery, Codeigniter and Bootstrap from the early stage. I believe in Hardworking and Consistency.
We are Recommending you
- Laravel WhereNotIn Query Example
- Laravel Wherein Query Example
- How to use whereHas with orWhereHas in Laravel?
- Where condition in Laravel Relationship Example
- Laravel - Where Condition with Two Columns Example
- Laravel Where Clause with date_format() Example
- Laravel Like Query Example using Eloquent Where Clause
- Laravel Where Clause with MySQL Function Example
- Laravel Query Builder Where Exists Example