Laravel whereIn and whereNotIn Query Example

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

In this article, we will see the laravel whereIn and whereNotIn query examples. laravel query builder provides many different types of queries to filter data from databases. The whereIn method verifies that a given column's value is contained within the given array and the whereNotIn method verifies that the given column's value is not contained in the given array.

Also, you can check if the value exists or not using the whereIn function in laravel 6, laravel 7, and laravel 8. You may create whereIn and whereNotIn subquery in laravel 7/8.

So, let's see laravel 7/8 wherein the query and SQL in the query example.

Syntax:

whereIn(Coulumn_name, Array)

 

Example: 

SQL Query

SELECT * FROM students WHERE roll_no IN (1,2,3) 

 

Laravel whereIn Query

public function index()
{
    $students = Student::select("*")
                ->whereIn('roll_no', [1,2,3])
                ->get();
  
    dd($students);                    
}

 

Laravel whereNotIn Query

public function index()
{
    $roll_no = '1,2,3';
    $array1 = explode(',', $roll_no);
    
    $student = Student::select("*")
                    ->whereNotIn('roll_no', $array1)
                    ->get();
  
    dd($student);                    
}

 

Recommended Post
Featured Post
Carbon Add Minutes In Laravel
Carbon Add Minutes In Laravel

In this example, we will see carbon add minutes in laravel. Here we will give you a simple example of laravel carbo...

Read More

Dec-11-2020

How To Create Line Chart In Laravel 9 Using Highcharts
How To Create Line Chart In La...

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

Read More

Oct-04-2022

Laravel 10 Apexcharts Bar Chart Example
Laravel 10 Apexcharts Bar Char...

In this article, we will see the laravel 10 apexcharts bar chart example. Here, we will learn about how to create a bar...

Read More

May-24-2023

Bootstrap Session Timeout Example In Laravel
Bootstrap Session Timeout Exam...

In this tutorial, I will show you a session timeout example in laravel. After a set amount of idle time, the bootstrap w...

Read More

Jun-05-2020