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

•

1891 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

Make PhpStorm Smarter for Laravel Development

2 years ago

How to Validate Password in Laravel Using Rule

2 years ago

How to Multi-Line Truncate Text in Tailwind CSS

2 years ago

How to Eager Loading Specific Columns in Laravel

2 years ago

Vue Js Prevent Methods and Events From Spamming Using Debounce

2 years ago

How to Create Model, Migration and Controller Using Single Artisan Command in Laravel

1 year ago