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

•

2034 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.

Laravel Snippets

new

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

Patreon

Previous Snippet

Setting up Laravel Breeze for new Laravel Project

Next Snippet

How to Define Computed Properties in Laravel Livewire

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

new

PostSrc Code Components

Collection of Tailwind CSS components for everyone to use. Browse all of the components that are right for your project.

View Components

Share this snippet

Sponsors 👑

+ Add Yours

Other Code Snippets

All Snippets

How to Delete Whole Collection In Laravel

2 years ago

How to Rendered Blade View as a String in Laravel

2 years ago

How to Query Between 2 Dates in Laravel Eloquent

2 years ago

How to Place Composer Bin Directory in PATH in MacOS or Linux

2 years ago

How to Change Laravel Nova Resource Name

2 years ago

How to Enhance SEO with Facebook Open Graph Tags

1 year ago