Laravel where and orWhere Condition Example

Websolutionstuff | Jan-11-2021 | Categories : Laravel PHP

In this article, we will see laravel where and orWhere condition example. we will give you a very simple example of the laravel where() and orWhere() condition and also we will give you an example of where() and orWhere in a single query in laravel 6/7/8. You can use the where and orwhere method in laravel 6, laravel 7, and laravel 8.

For the where() and orWhere() methods 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. The third argument is the value to compare against the column's value.

So, let's see laravel 7/8 where query and laravel 7/8 orwhere query.

Syntax of where() query in laravel 6/7/8

where(Column Name, Operator, Value);

 

Example of where() condition in laravel 6/7/8

$users = DB::table('users')
                ->where('id', '=', 10)
                ->where('department', '=', 'web development')
                ->where('age', '>', 35)
                ->get();

 

Now I will show you an example of orWhere() query in laravel 6/7/8 and how to write orWhere() condition in laravel. So first we will see SQL query for better understanding.

SQL OR Example

SELECT * FROM users WHERE id='10' OR salary='20000';

 

Example of orWhere() condition in laravel 6/7/8

$users = DB::table('users')
                    ->where('salary', '>', 20000)
                    ->orWhere('name', 'Maria')
                    ->get();

 

Recommended Post
Featured Post
How Generate PDF From HTML View In Laravel
How Generate PDF From HTML Vie...

In this example, I will teach you how to generate PDF files from an HTML view in laravel. For generating PDF files I wil...

Read More

Jun-01-2020

Laravel 8 Custom Email Verification Tutorial
Laravel 8 Custom Email Verific...

In this article, we will see an example of laravel 8 custom email verification. Many web applications require users...

Read More

Dec-29-2021

How To Upload Large CSV File Using Queue In Laravel 9
How To Upload Large CSV File U...

In this article, we will see how to upload a large CSV file using queue in laravel 9. Here we will learn large numb...

Read More

Sep-16-2022

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