Laravel 9 whereIn / whereNotIn / orWhereIn / orWhereNotIn

Websolutionstuff | Oct-17-2022 | Categories : Laravel

In this article, we will see Laravel 9 whereIn / whereNotIn / orWhereIn / orWhereNotIn Query Example. The whereIn() method is used to check the value in a given range of the value. So, we will learn laravel 9 whereIn query, laravel 9 whereNotIn query, laravel 9 orWhereIn query, laravel 9 orWhereNotIn query example.

The whereIn method verifies that a given column's value is contained within the given array. The whereNotIn method verifies that the given column's value is not contained in the given array.

Syntax of SQL:

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

 

Example 1:

In this example, we will retrieve all records of employees with IN conditions.

SELECT * FROM employee WHERE emp_id IN (1,2,3) 

 

Syntax of Laravel:

whereIn(Coulumn Name, Array of Value)

 

 

Example 2:

In this example, we will retrieve data using the whereIn() method.

$employee = DB::table('employee')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

 

Example 3:

In this example, we will retrieve data using the whereNotIn() method.

$employee = DB::table('employee')
                    ->whereNotIn('id', [1, 2, 3])
                    ->get();

 

Example 4:

In this example, we will retrieve data using the orWhereIn() method.

$employee = DB::table('employee')
                    ->where('role','=','software engineer')
                    ->orWhereIn('emp_id', [1, 2, 3])
                    ->get();

 

 

Example 5:

In this example, we will retrieve data using the orWhereNotIn() method.

$employee = DB::table('employee')
                    ->where('role','=','software engineer')
                    ->orWhereNotIn('emp_id', [1, 2, 3])
                    ->get();

 


You might also like:

Recommended Post
Featured Post
How To Install Bootstrap In React JS
How To Install Bootstrap In Re...

In this article, we will see how to install bootstrap in react js. Also, we will see how to use bootstrap in react...

Read More

Sep-08-2022

How to Deploy Laravel on Heroku with Database
How to Deploy Laravel on Herok...

In this article, we will see how to deploy laravel on heroku with database. Heroku is a cloud platform as...

Read More

Feb-12-2021

Laravel 9 AJAX CRUD Example
Laravel 9 AJAX CRUD Example

In this post, we will learn how to create ajax crud operations in laravel 9. here, we will perform laravel 9 ajax c...

Read More

Feb-11-2022

Laravel 10 Delete Multiple Records Using Checkbox
Laravel 10 Delete Multiple Rec...

In this article, we will see laravel 10 delete multiple records using the checkbox. Here, we will learn about how to del...

Read More

Mar-03-2023