Rails 3: Get Random Record

by 
Thing.first(:order => "RANDOM()") # For MySQL :order => "RAND()", - thanx, @DanSingerman
# Rails 3
Thing.order("RANDOM()").first

or

Thing.first(:offset => rand(Thing.count))
# Rails 3
Thing.offset(rand(Thing.count)).first

Actually, in Rails 3 all examples will work. But using order RANDOM is quite slow for big tables but more sql-style

UPD. You can use the following trick on an indexed column (PostgreSQL syntax):

select * 
from my_table 
where id >= trunc(
  random() * (select max(id) from my_table) + 1
) 
order by id 
limit 1;

More Related Contents:

  1. How to get a random number in Ruby
  2. Rails 3, has_one / has_many with lambda condition
  3. do..end vs curly braces for blocks in Ruby
  4. ActiveRecord: size vs count
  5. Connecting Rails 3.1 with Multiple Databases
  6. In Ruby on Rails, to extend the String class, where should the code be put in?
  7. How do I replace accented Latin characters in Ruby?
  8. How to chain scope queries with OR instead of AND?
  9. Rails 5: ActiveRecord OR query
  10. incompatible character encodings: ASCII-8BIT and UTF-8
  11. Alias for column names in Rails
  12. ActiveRecord Find By Year, Day or Month on a Date field
  13. Rails 3 devise, current_user is not accessible in a Model ?
  14. STI, one controller
  15. LEFT OUTER joins in Rails 3
  16. How to test for (ActiveRecord) object equality
  17. Paginating an Array in Ruby with will_paginate
  18. Regular expressions with validations in RoR 4
  19. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  20. Convert HTML to word file ?
  21. Convert UTC to local time in Rails 3
  22. Ruby: problem installing EventMachine under Windows 7
  23. How to implement bulk insert in Rails 3
  24. Rails 3.1 limit user created objects
  25. Is there a way to avoid automatically updating Rails timestamp fields?
  26. Ruby on Rails 3 howto make ‘OR’ condition
  27. Adding foreign key to a rails model
  28. Rails catch-all/globbing routes
  29. Always getting 401 Unauthorized with new install of Rails + Devise
  30. Customizing Devise error messages in Rails 3?

Leave a Comment