> For the complete documentation index, see [llms.txt](https://learnphp.gitbook.io/learnphp/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnphp.gitbook.io/learnphp/laravel-advanced/laravel-orderby-random-using-rand-and-db-raw-example-ok.md).

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

https\://www\.itsolutionstuff.com/post/laravel-5-orderby-random-using-rand-and-dbraw-exampleexample.html

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

By Hardik Savani May 4, 2016 Category : LaravelPlayUnmuteLoaded: 1.17%Fullscreen[![VDO.AI](https://a.vdo.ai/core/assets/img/logo.svg)](https://vdo.ai/?utm_medium=video\&utm_term=itsolutionstuff.com\&utm_source=vdoai_logo)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...

Read Also: [Order by using multiple columns and manually array field in Laravel?](https://www.itsolutionstuff.com/post/order-by-using-multiple-columns-and-manually-array-field-in-laravelexample.html)

```php
return DB::table("posts")
->select("posts.*")
->orderBy(DB::raw('RAND()'))
->take(8)
->get();
// select `posts`.* from `posts` order by RAND() asc limit 8
```