Laravel 7/6 Wherenotin Eloquent Query Example

In this example,I will learn you how to use wherenotin query in laravel 6.you can simply use to wherenotin query in your controller.

We may sometimes require to use select query with where not in clause. we can simply make query using MySQL.

for example,your table 5 record in 3 record not get that define to wherenotin query in contoller.

you will check this wherenotin query in your controller.bellow example

Example 1 :

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereNOTIn('id',[1,2])->get();

    dd($users);
}

Example 2 :

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = DB::table('users')
                ->whereNOTIn('id', [1, 2])
                ->get();

    dd($users);
}

Example 3 :

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $myArray = ["jaydev","sunil","kanak"];

    $users = User::whereNOTIn('name',$myArray)->get();

    dd($users);
}

It will help you....