how to select several rows from database(eloquent) order by rand in laravel

Question

i want to select several random rows from database, something like this

select * from table order by rand limit 10

how to do it in Laravel eloquent model?

Possible duplicate of [Laravel - Eloquent or Fluent random row](http://stackoverflow.com/questions/13917558/laravel-eloquent-or-fluent-random-row) — Laerte, Feb 10 '16 at 16:35

score 2 · Accepted Answer · answered Feb 10 '16 at 16:33

2

Do something like this:

User::orderBy(DB::raw('RAND()'))->take(10)->get();

answered Feb 10 '16 at 16:33

Jilson Thomas

score 1 · Answer 2 · answered Feb 10 '16 at 22:11

1

It's simple than it looks like, you just have to use the suffle() collections method.

The shuffle method randomly shuffles the items in the collection:

$collection = collect([1, 2, 3, 4, 5]);
$shuffled = $collection->shuffle();
$shuffled->all();
// [3, 2, 5, 1, 4] // (generated randomly)

For further methods and info you should check the laravel eloquent docs, there are methods almost for everything.

Cheers.

answered Feb 10 '16 at 22:11

thank you for reply! thats good variant, but check another answer, theres an easier way) – nooby Feb 11 '16 at 10:58
1

You can always use fluent :), that's the way it is explained in Laravel docs. :) – Victor Hugo Avelar Feb 11 '16 at 12:36

2 Answers2