Laravel 9 whereBetween Query Example

Websolutionstuff | Oct-14-2022 | Categories : Laravel

In this article, we will see laravel 9 whereBetween query example. The whereBetween() method is used to check value from two columns or a given range of the value. We will learn wherebetween queries in laravel 9. The whereBetween method verifies that a column's value is between two values.

So, let's see laravel 9 wherebetween query example.


The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;


Example 1:

In this example, we will retrieve all records of employees with salaries between 10000 to 20000. 

SELECT * FROM employee
WHERE salary BETWEEN 10000 AND 20000;


whereBetween() Syntax of Laravel

 In the whereBetween() method first argument is the column name and the second argument is an array of range values.

whereBetween('Column Name', [Range of Value]);



Example 2:

In laravel 9, you can get data from the given range value using the below example query.

$employee = DB::table('employee')
           ->whereBetween('salary', [10000, 20000])


Example 3:

In this example, we will retrieve data from a given two date range using the whereBetween().

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Employee;
use Carbon\Carbon;
class RegisterController extends Controller
    public function index(Request $request)
        $employee = Employee::whereBetween('joined_at',[$request->join_date,$request->resign_date])->get();


You might also like:

Recommended Post
Featured Post
Stripe Payment Gateway Integration Example In Laravel 8
Stripe Payment Gateway Integra...

In this article, we will see a stripe payment gateway integration example in laravel 8. The stripe payment gateway...

Read More


Laravel 9 Flash Message Example
Laravel 9 Flash Message Exampl...

In this article, we will see a laravel 9 flash message example. Here, we will learn how to create or implement flash mes...

Read More


How To Check RAM And CPU Usage In Laravel
How To Check RAM And CPU Usage...

In this tutorial, I will show you how to check RAM and CPU usage in laravel in ubuntu OS. Many times we requir...

Read More


How To Send Email In Laravel 9 Using Mailgun
How To Send Email In Laravel 9...

In this article, how to send email in laravel 9 using mailgun. we will learn laravel 9 to send emails using mailgun...

Read More