Laravel 9 orWhere Condition Example

Websolutionstuff | Oct-13-2022 | Categories : Laravel

In this article, we will see the laravel 9 orWhere condition example. Where condition is joined together using the and operator. The orWhere condition is joined together using the or operator. The orWhere method is the same as the where() method. So, we will learn how to write multiple where conditions with orWhere in laravel 9, and also we will see SQL query of or condition.

The orWhere 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 orWhere conditions in laravel 9.

Syntax of the orWhere() condition.

orWhere(Column Name, Operator, Value);

 

Example 1:

In this example, we will get the records using SQL query with OR condition.

SELECT * FROM users WHERE salary > 20000 OR role='software engineer';

 

Example 2:

In this example, we will retrieve records of the user's who has votes greater than 80 or whose name is dell.  

$users = DB::table('users')
                    ->where('votes', '>', 80)
                    ->orWhere('name', 'dell')
                    ->get();

 

 

Example 3:

 In this example, we will see the orWhere() condition with a subquery.

$users = DB::table('users')
            ->where('votes', '>', 80)
            ->orWhere(function($query) {
                $query->where('name', 'dell')
                      ->where('votes', '>', 50);
            })
            ->get();

The example above will produce the following SQL.

select * from users where votes > 80 or (name = 'dell' and votes > 50)

 

Example 4:

In this example, we will retrieve data using the where() and orWhere() with the model.

$users = User::where('is_active','=', true)->orWhere('plan','!=','basic')->get();

 


You might also like:

Recommended Post
Featured Post
How To Download Youtube Video Using jQuery
How To Download Youtube Video...

In this tutorial I will show you how to download youtube video using jquery or how to download youtube video from s...

Read More

Sep-27-2021

How To Add Column In Existing Table In Laravel 10
How To Add Column In Existing...

In this article, we will see how to add a column to the existing table in laravel 10 migration. Here, we will learn...

Read More

Apr-24-2023

How to Create Components in Angular 16
How to Create Components in An...

In this article how to create components in angular 16. Here, we will learn about how to use angular component...

Read More

Jun-02-2023

How To Image Upload Using Ajax In Laravel 9
How To Image Upload Using Ajax...

In this article, we will see how to image upload using ajax in laravel 9. Here, we will learn about image upload in...

Read More

Feb-07-2023