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 Export CSV File in Laravel
How to Export CSV File in Lara...

In this post we will see how to export CSV file in laravel, Export csv file in laravel is most common function...

Read More

Apr-30-2021

Angular 15: Unleashing Modern Web Development
Angular 15: Unleashing Modern...

Angular 15 is the latest iteration of one of the most popular JavaScript frameworks for building dynamic web application...

Read More

Jun-05-2023

Laravel 9 Form Class Not Found
Laravel 9 Form Class Not Found

In this article, we will fix the laravel 9 form class not found error, many times we have received errors like lara...

Read More

Sep-19-2022

Laravel 11 Livewire Multi Step Wizard Form
Laravel 11 Livewire Multi Step...

In this article, we'll see how to create a multi-step form wizard in laravel 11 Livewire. Here, we'll see step b...

Read More

Jun-17-2024