Laravel - Orderby Random using rand() and DB::raw() example

By Hardik Savani September 6, 2020 Category : Laravel

Sometimes, we require to get randomly data using laravel query builder. you can use mysql rand() with order by. If you want to get random data using laravel eloquent then we need to use DB::raw(). In bellow example you can i use DB::raw().

In this example i use DB::raw('RAND()') inside orderBy() and also add limit of 8 number of record, so you can easily implement in your laravel project. so let's try...

return DB::table("posts")

->select("posts.*")

->orderBy(DB::raw('RAND()'))

->take(8)

->get();

We are Recommending you