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
Laravel tips: DB Models and Eloquent - Part 2
Laravel tips: DB Models and El...

Laravel, the PHP web application framework, is renowned for its elegant and efficient approach to handling databases thr...

Read More


How to Manage Time Zones in React.js Applications
How to Manage Time Zones in Re...

In the interconnected world of web development, where applications are accessed by users spanning multiple time zones, t...

Read More


How To Roll back Specific Migration In Laravel
How To Roll back Specific Migr...

In this article, we will explore the process of rolling back specific migrations in Laravel, focusing on Laravel version...

Read More


How to install GCC on Ubuntu 22.04
How to install GCC on Ubuntu 2...

Hello there! If you're diving into the world of programming on Ubuntu 22.04 and want to get your hands dirty with so...

Read More