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
Laravel 9 Phone Number Validation Using Regex
Laravel 9 Phone Number Validat...

In this article, we will see laravel 9 phone number validation using regex. In laravel 9 we will see different meth...

Read More

Oct-25-2022

How To Create Pie Chart In Laravel 9 Using Highcharts
How To Create Pie Chart In Lar...

In this article, we will see how to create a pie chart in laravel 9 using highcharts. A pie chart is a circular statisti...

Read More

Oct-05-2022

Bootstrap Modal In Angular 13
Bootstrap Modal In Angular 13

In this article, we will see the bootstrap modal in angular 13. Ng Bootstrap is developed from bootstrap and they p...

Read More

Jun-10-2022

How To Generate PDF and Send Email In Laravel 8
How To Generate PDF and Send E...

In this tutorial we will see how to generate pdf and send email in laravel 8. For generating PDF file we will use l...

Read More

Dec-20-2021