Laravel how to get data random row use Postgres SQL?

Question

In Laravel 5 framework: How can I select a random row using Eloquent Postgres SQL?

i want get random 3 recomment product.

i find code:

$recomment_product = Product::whereRaw("name = '".$product->name."' and gender = '".$product->gender."' and client_target = '".$product->client_target."'")->orderByRaw(DB::raw("RAND()"))->take(3)->get();

But it not work. Please Help!

IndianCoding · Accepted Answer · 2018-12-11 09:14:18Z

3

Eloquent has inRandomOrder() method.

$recomment_product = Product::where('name', $product->name)
    ->where('gender', $product->gender)
    ->where('client_target', $product->client_target)
    ->inRandomOrder()
    ->take(3)
    ->get();

answered Dec 11, 2018 at 9:14

IndianCoding

2,6831 gold badge9 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Laravel how to get data random row use Postgres SQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related