Laravel – Eloquent or Fluent random row

by

Laravel >= 5.2:

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

or to get the specific number of records

// 5 indicates the number of records
User::inRandomOrder()->limit(5)->get();
// get one random record
User::inRandomOrder()->first();

or using the random method for collections:

User::all()->random();
User::all()->random(10); // The amount of items you wish to receive

Laravel 4.2.7 – 5.1:

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

Laravel 4.0 – 4.2.6:

User::orderBy(DB::raw('RAND()'))->get();

Laravel 3:

User::order_by(DB::raw('RAND()'))->get();

Check this article on MySQL random rows. Laravel 5.2 supports this, for older version, there is no better solution then using RAW Queries.

edit 1: As mentioned by Double Gras, orderBy() doesn’t allow anything else then ASC or DESC since this change. I updated my answer accordingly.

edit 2: Laravel 5.2 finally implements a wrapper function for this. It’s called inRandomOrder().

More Related Contents:

  1. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  2. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  3. Automatically deleting related rows in Laravel (Eloquent ORM)
  4. Get the Last Inserted Id Using Laravel Eloquent
  5. How to do this in Laravel, subquery where in
  6. Laravel Eloquent Query Using WHERE with OR AND OR?
  7. How to insert multiple rows from a single query using eloquent/fluent
  8. Laravel update model with unique validation rule for attribute
  9. How can I convert many statement mysql to laravel eloquent?
  10. Add a custom attribute to a Laravel / Eloquent model on load?
  11. Eloquent ORM Code Hinting in PhpStorm
  12. Creating and Update Laravel Eloquent
  13. How to sort a Laravel query builder result by multiple columns?
  14. Laravel Eloquent Sum of relation’s column
  15. Get the Query Executed in Laravel 3/4
  16. What does “Mass Assignment” mean in Laravel?
  17. Laravel Checking If a Record Exists
  18. How to exclude certains columns while using eloquent
  19. Laravel 5 hasMany relationship on two columns
  20. Laravel Recursive Relationships
  21. Laravel Eloquent – Attach vs Sync
  22. How to create a subquery using Laravel Eloquent?
  23. Eloquent model mass update
  24. Natural ORDER in Laravel Eloquent ORM
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. Laravel Eloquent: How to get only certain columns from joined tables
  27. How can I query raw via Eloquent?
  28. A __construct on an Eloquent Laravel Model
  29. How to get last insert id in Eloquent ORM laravel
  30. Laravel Many to many self referencing table only works one way

Leave a Comment