i have a rails table called users and would love to know the best way to get random records from the database so it would be fast as if getting it like the normal
@users = User.all
THANKS....
Asked
Active
Viewed 1,848 times
1
-
what do u mean by 'random' records? – Kunal S. Kushwah Jul 17 '13 at 16:16
-
1possible duplicate of [Random record in ActiveRecord](http://stackoverflow.com/questions/2752231/random-record-in-activerecord) – James Chevalier Jul 17 '13 at 16:16
-
@Kunal S. Kushwah i mean not in an order like descending, ascending , created at ..... just in random – Kadismile Jul 18 '13 at 06:09
1 Answers
3
Try this:
# Get 5 random users
@users = User.order('RAND()').limit(5)
Note that the RAND() (MySQL) function is called RANDOM() in PostgreSQL and SQLite.
Alessandro Desantis
- 14,098
- 1
- 26
- 32
-
will this be very efficient if for instance i have 5000 users and different people at different locations are trying to get random users from the application? – Kadismile Jul 18 '13 at 06:07
-
1
-