Laravel雄辩的运算符之间如何使用 [英] Laravel Eloquent how to use between operator
本文介绍了Laravel雄辩的运算符之间如何使用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正试图在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屋!
查看全文