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

•

1396 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 Define Computed Properties in Laravel Livewire

1 year ago

How to Record Laravel Horizon Metrics (Snapshot)

1 year ago

Laravel Inertia Pagination Component

9 months ago

How to Bind Event Handlers in React JS Component by Avoiding Constructor Declaration

1 year ago

Xcode Command Line Tools Mac Installation Guide

1 year ago

Redirect to Specific Controller Method in Laravel

1 year ago