How to Select Random Rows in Laravel: Eloquent, Fluent, and Collections Methods?

Selecting Random Rows in Laravel: Eloquent and Fluent Approaches

In Laravel, there are multiple methods to retrieve a random row from a database table. Using Eloquent or Fluent, developers can access this functionality for various scenarios.

Eloquent Interface

Starting with Laravel 5.2, the Eloquent interface provides a dedicated inRandomOrder() method. This method shuffles the query results, effectively selecting a random row:

User::inRandomOrder()->get();

To specify a specific number of random records, use the limit() method:

User::inRandomOrder()->limit(5)->get();

Fluent Interface

For older versions of Laravel (before 5.2), you can use the Fluent interface to achieve a similar effect:

User::orderByRaw("RAND()")->get();

Collections Method

Alternatively, for Laravel 5.1 and above, you can use the random() method on collections generated by Eloquent queries. This approach returns a single random record or a specified number of them:

User::all()->random();
User::all()->random(10);

Remember to consult the official Laravel documentation for specific version compatibility and syntax variations.

The above is the detailed content of How to Select Random Rows in Laravel: Eloquent, Fluent, and Collections Methods?. For more information, please follow other related articles on the PHP Chinese website!