Search code examples
phpsqllaravellaravel-4eloquent

Laravel Eloquent how to use between operator

I am trying to find an elegant way in Eloquent and Laravel to say

select * from UserTable where Age between X and Y

Is there a between operator in Eloquent (I can't find it).

The closest i have gotten so far is chainging my query like this

$query->where(age, '>=', $ageFrom)
      ->where(age, '<=', $ageTo);

I also came across whereRaw that seems to work

$query->whereRaw('age BETWEEN ' . $ageFrom . ' AND ' . $ageTo . '');

Is there an actual Eloquent way (not raw) that deals with ranges?

Solution 
  • $query->whereBetween('age', [$ageFrom, $ageTo]);

    Still holds true for Laravel 10+ https://laravel.com/docs/10.x/queries#additional-where-clauses