Have you encountered a challenge where you need to fetch records from the database in no particular order using Laravel?
I found myself at this point once and here is how I solved it. All thanks to dear Google!😍
This is a regular SQL query to fetch records randomly:
select * from `users` order by RAND() ```
But in Laravel, there is a method named
```inRandomOrder()```
which simply fetches the records in random order.
Here is a list of the few ways this method can be used:
```PHP
//Fetch all records in random order
Model::inRandomOrder()->get();
// 5 indicates the number of records
Model::inRandomOrder()->limit(5)->get();
//Fetc all records in pages or sets of 6
Model::inRandomOrder()->paginate(6)->get();
// get one random record
Model::inRandomOrder()->first()
The helper method can also be used like this:
Model::where('name',$name)->inRandomOrder()->get();
PS: The
inRandomOrder()
method can also be used alongside other helper methods for fetching records likepaginate()
andlimit()
.
Thats It!😍
I trust this will be of great assistance🥰. I would also love to learn more about this so please feel free to drop your comments or send a direct message on twitter.
Questions are welcomed. Don't forget to connect with me on socials.😎
Thank you😎
Top comments (6)
Thanks you.
I will use it in a project that I am working on
Thats amazing, thank you.
I used it today 😅
Amazing💪, I'm open to futher discussions
Thanks for sharing
Thank you