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
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

Nov-26-2020

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

Dec-27-2022

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

Jul-29-2020

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

Jul-29-2022