Laravel 9 Where Condition Example

Websolutionstuff | Oct-12-2022 | Categories : Laravel

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.

where(Column Name, Operator, Value);

 

Example 1:

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();

 

Example 2:

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();

 

 

Example 3:

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();

 

Example 4:

In this example, we will retrieve records using the model.

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

 


You might also like:

Recommended Post
Featured Post
How To Create Dependent Dropdown In Laravel
How To Create Dependent Dropdo...

In this article, we will see how to create a dependent dropdown list in laravel using ajax. Many times we have requ...

Read More

Jul-05-2020

Implement Secure SSO with OAuth2 in Laravel 11
Implement Secure SSO with OAut...

Hello, laravel web developers! In this tutorial, I'll show you how to implement a secure Single Sign-On (SSO) system...

Read More

Oct-16-2024

How To Validate 10 Digit Mobile Number Using Regular Expression
How To Validate 10 Digit Mobil...

In This small tutorial, I will explain to you how to validate a 10-digit mobile number using regular expressions in...

Read More

Jun-15-2020

How to Upload Image to Storage Folder in Laravel 10
How to Upload Image to Storage...

As I delve into Laravel 10, a true powerhouse in the realm of PHP frameworks, I've found it to be a game-changer for...

Read More

Sep-29-2023