DEV Community


Posted on • Originally published at


Laravel whereBetween Query Example

In this artical I will show laravel whereBetween query example. As we know SQL provides many diffrent type of method or query to get filtered data from database. So, in this post we will learn laravel orWhereBetween query builder example.

Here we will see example of laravel wherebetween dates example,Here i have added laravel wherebetween with orwherebetween SQL query as well as Laravel query.

Example of whereBetween() condition in laravel

$students = DB::table('Register')
           ->whereBetween('RollNo', [1, 50])
Enter fullscreen mode Exit fullscreen mode

Now I will show you example of whereBetween() query in laravel 8 and how to write whereBetween() condition in laravel. So first we will see SQL query for better understanding.

SQL Query Example

select * from `Register` where `rollno` between ? and ?
Enter fullscreen mode Exit fullscreen mode

Get all records between two dates using wherebetween in laravel


namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Register;
use Carbon\Carbon;

class RegisterController extends Controller
    public function index(Request $request)
      $names = Register::whereBetween

Enter fullscreen mode Exit fullscreen mode

You might also like :

Latest comments (0)

An Animated Guide to Node.js Event Loop

Node.js doesnโ€™t stop from running other operations because of Libuv, a C++ library responsible for the event loop and asynchronously handling tasks such as network requests, DNS resolution, file system operations, data encryption, etc.

What happens under the hood when Node.js works on tasks such as database queries? We will explore it by following this piece of code step by step.