How to fetch random record using eloquent model

Question

I am trying to fetch random number of rows from table in laravel 5.7, but i could not find any solution. I have use

 Model::all()->random(2);

It work fine. But i need to apply where clause with it like Model::select('column')->where('column','value')->random(number of rows'); So how can i achieve this using eloquent. Please any suggestions for me.

https://stackoverflow.com/questions/13917558/laravel-eloquent-or-fluent-random-row?rq=1 — piscator, Mar 05 '19 at 09:44
I know that, but i need make it with where clause . like Modell::where('condition')->random(1); — Riaz Khan, Mar 05 '19 at 09:47
Just to clarify, would you like to fetch a random row or a random number of rows? — D Malan, Mar 05 '19 at 09:59

score 13 · Answer 1 · answered Mar 05 '19 at 09:54

13

You can simply add to chain inRandomOrder, as suggested here:

Laravel - Eloquent or Fluent random row

And then limit your dataset.

Model::select('column')
    ->where('column','value')
    ->inRandomOrder()
    ->limit(2) // here is yours limit
    ->get();

answered Mar 05 '19 at 09:54

Roman Meyer

2,634
2
20
27

Thank you sooo much it work...... – Riaz Khan Mar 05 '19 at 10:00

score 4 · Answer 2 · answered Mar 05 '19 at 09:50

4

You could use the inRandomOrder method in combination with first, like this: Model::inRandomOrder()->select('column')->where('column','value')->first();

answered Mar 05 '19 at 09:50

D Malan

10,272
3
25
50

I have tried it, but i return no row. – Riaz Khan Mar 05 '19 at 09:53
1

Then it sounds like your query doesn't have any results. – D Malan Mar 05 '19 at 09:57
I try it again now it work thank you.. – Riaz Khan Mar 05 '19 at 10:02
1

yes exactly..... that was the reason – Riaz Khan Mar 05 '19 at 10:03

How to fetch random record using eloquent model

2 Answers2