Laravel - 雄辩或流畅的随机排 [英] Laravel - Eloquent or Fluent random row
问题描述
如何使用Laravel框架中的口语或流利来选择一个随机行?
How can I select a random row using Eloquent or Fluent in Laravel framework?
我知道通过使用SQL,您可以按RAND()进行排序。不过,我想获得一个随机的行而不用对初始查询之前的记录数进行计数。
I know that by using SQL, you can do order by RAND(). However, I would like to get the random row without doing a count on the number of records prior to the initial query.
任何想法?
推荐答案
Laravel> = 5.2:
Laravel >= 5.2:
User::inRandomOrder()->get();
Laravel 4.2.7 - 5.1:
Laravel 4.2.7 - 5.1:
User::orderByRaw("RAND()")->get();
Laravel 4.0 - 4.2.6:
Laravel 4.0 - 4.2.6:
User::orderBy(DB::raw('RAND()'))->get();
Laravel 3:
Laravel 3:
User::order_by(DB::raw('RAND()'))->get();
检查 本文 在MySQL随机行上。 Laravel 5.2支持这一点,对于较旧版本,没有更好的解决方案,然后使用 RAW查询。
编辑1:如Double Gras所述,orderBy()不允许任何其他的ASC或DESC,因为此更改。我更新了我的答案。
edit 1: As mentioned by Double Gras, orderBy() doesn't allow anything else then ASC or DESC since this change. I updated my answer accordingly.
编辑2: Laravel 5.2终于实现了一个包装函数。它被称为 inRandomOrder()。
edit 2: Laravel 5.2 finally implements a wrapper function for this. It's called inRandomOrder().
这篇关于Laravel - 雄辩或流畅的随机排的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!