ItSolutionStuff.com

How to Get Random Records from Database in Laravel?

By Hardik Savani • April 16, 2024
Laravel

Hey Friends,

Now, let's see a tutorial of how to get records in random order in laravel. This article will give you a simple example of laravel get random record from model. you can see laravel get random data from database. we will help you to give an example of laravel get random record from database.

You can use this example with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 versions.

In this post, i will give you simple two ways to get order by random records from database in laravel. we will use inRandomOrder() and RAND() MySQL function to getting random records.

so, let's see both example one by one.

Example 1: Laravel Order By Random Records using inRandomOrder()

you can see the below controller code:

Controller Code:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

class UserController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$users = User::select("*")

->inRandomOrder()

->get();

dd($users->toArray());

}

}

Example 2: Laravel Order By Random Records using RAND()

you can see the below controller code:

Controller Code:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

use DB;

class UserController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$users = User::select("*")

->orderBy(DB::raw('RAND()'))

->get();

dd($users->toArray());

}

}

I hope it can help you...

Tags: Laravel
Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

Laravel 9 Many to Many Eloquent Relationship Tutorial

Read Now →

Laravel Eloquent without() and withOnly() Method Example

Read Now →

Laravel Eloquent doesntHave() Condition Example

Read Now →

Laravel Eloquent orWhereHas() Condition Example

Read Now →

Laravel Eloquent whereRelation() Condition Example

Read Now →

Laravel Eloquent whereHas() Condition Example

Read Now →

Laravel Eloquent Select Single Column to Array Example

Read Now →

Laravel Eloquent Group By Year with Sum Example

Read Now →

Laravel Eloquent Model Custom Function Example

Read Now →

Laravel Eloquent withMin(), withMax() and withAvg() Example

Read Now →

Laravel Eloquent withSum() and withCount() Example

Read Now →

Laravel Eloquent updateOrCreate Example

Read Now →

Laravel Eloquent Where Like Query Example Tutorial

Read Now →

How to Get Query Log in Laravel Eloquent?

Read Now →