Laravel雄辩的运算符之间如何使用 [英] Laravel Eloquent how to use between operator

问题描述

我正试图在Eloquent和Laravel中找到一种优雅的表达方式

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

select * from UserTable where Age between X and Y

在Eloquent中是否存在一个中间运算符(我找不到它).

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?

推荐答案

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

查看此处: http://laravel.com/docs/4.2/queries#selects

对于Laravel 5仍然适用: https://laravel.com/docs/5.8 /queries#where-clauses

Still holds true for Laravel 5: https://laravel.com/docs/5.8/queries#where-clauses

这篇关于Laravel雄辩的运算符之间如何使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！