Laravel Php take random results from mysql query [duplicate]

Question

I cannot find the way to display random results from a collection in laravel mysql. My query:

public function getTabletsProducts()
{
    return DB::table('products')
        ->orderBy('created_at')
        ->where('categoryName', 'All Tablets')
        ->where('sellingPrice', '<', 1000)
        ->take(6)
        ->orderByRaw("RAND()")
        ->get();
}

They weird thing is that I believed that using RAND would perform the job, but my results display same values using or not (rand).

any help appreciated.

See also: laravel.com/docs/5.5/queries#ordering-grouping-limit-and-offset — Webdesigner
– Webdesigner, Commented Oct 1, 2017 at 21:51

GabMic · Accepted Answer · 2017-10-01 22:32:48Z

0

You should use take(6)->inRandomOreder()->get(). That should do the trick.

edited Oct 1, 2017 at 22:32

answered Oct 1, 2017 at 22:25

GabMic

1,4821 gold badge21 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tohid Dadashnezhad · Accepted Answer · 2017-10-01 22:36:48Z

0

I'm not sure, but I think that's because you take 6 items at first and then order them randomly. So you always get the same or the near result. If I were you I would try this:

public function getTabletsProducts()
{
return DB::table('products')
    ->where('categoryName', 'All Tablets')
    ->where('sellingPrice', '<', 1000)
    ->orderByRaw("RAND()")
    ->orderBy('created_at')
    ->take(6)
    ->get();
 }

answered Oct 1, 2017 at 22:36

Tohid Dadashnezhad

1,9481 gold badge18 silver badges28 bronze badges

1 Comment

Tohid Dadashnezhad Over a year ago

and bring the order by created at to the end of the script before take

Collectives™ on Stack Overflow

Laravel Php take random results from mysql query [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related