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.

BETWEEN Syntax of SQL

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])
           ->get();

 

Example 3:

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

<?php
  
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();
  
        dd($employee);
    }
}

 


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

Oct-13-2023

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

Sep-04-2023

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

Nov-11-2022

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

Jan-15-2024