Home / Snippets / How to Get Random Record in Laravel using Query Builder and Eloquent Model
How to Get Random Record in Laravel using Query Builder and Eloquent Model cover

How to Get Random Record in Laravel using Query Builder and Eloquent Model

2.1K

3 years ago

0 comments

There are 2 ways to get a random record in Laravel. You can make use of Laravel query builder as well as an eloquent model but either way you have to call the "inRandomOrder" method.

Using Query Builder
$randomUser = DB::table('users')
                ->inRandomOrder()
                ->first();

Using Eloquent Model
$randomComment = Comment::query()
                ->inRandomOrder()
                ->first();

Both of the queries above will return a random record.
notion avatar

Alaz

Week-end developer currently experimenting with web, mobile, and all things programming.

Topics:

Frontend

Resource

Average

Average

Support Us

If you like our tutorial, support us by being our Patreon or buy us some coffee ☕️

Welcome to PostSrc V3

PostSrc Dark Logo

You have to login to favorite this