Laravel Eloquent whereNotBetween() Query Example

Jul 15, 2020

Hi Guys,

In this example,I will learn you how to use whereNotBetween query in laravel.you can easy and simply use whereNotBetween in laravel.

The whereNotBetween method verifies that a column’s value lies outside of two values.

If you fetch some data from database in laravel and you may want to leave some data between two column values. In that case you can use laravel eloquent whereNotBetween cluase.

Example 1:

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

Example 2:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereNotBetween('created_at', [2020-07-15, 2020-07-23])
                ->get();
    dd($users);
}

Example 3:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users =  DB::table('users')
    			->whereNotBetween('created_at', [2020-07-10, 2020-07-15])
                ->get();
    dd($users);
}

It will help you...