Laravel whereIn and whereNotIn Query Example

In this example we have learn how to laravel whereIn and whereNotIn query example. laravel query builder provides many diffrent types of query to filter data from datatable.

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

Read Also :  Laravel Dynamic Dependent Select Box using jQuery Ajax

Also we will see laravel whereIn and laravel whereNotIn query with example.

Syntax :

whereIn(Coulumn_name, Array)

Laravel whereIn and whereNotIn Query 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);                    
}

 

Read Also :  Laravel Left Join Query Example