Posts Learn Snippets Categories Tags About
/

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

Learn how to get random record in Laravel, Make use of eloquent to get the random model and query builder to get random record

Created on Jul 06, 2021

9 views

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.

Created by

PostSrc poster

PostSrc

Full stack developer mainly focusing on the front end side of the web. The main author of PostSrc and loves writing tutorial and guides online.