Random record in ActiveRecord

by

Rails 6

As stated by Jason in the comments, in Rails 6, non-attribute arguments are not allowed. You must wrap the value in an Arel.sql() statement.

Model.order(Arel.sql('RANDOM()')).first

Rails 5, 4

In Rails 4 and 5, using Postgresql or SQLite, using RANDOM():

Model.order('RANDOM()').first

Presumably the same would work for MySQL with RAND()

Model.order('RAND()').first

This is about 2.5 times faster than the approach in the accepted answer.

Caveat: This is slow for large datasets with millions of records, so you might want to add a limit clause.

More Related Contents:

  1. Rails extending ActiveRecord::Base
  2. How to change default timezone for Active Record in Rails?
  3. Rails :include vs. :joins
  4. ActiveModel::ForbiddenAttributesError when creating new user
  5. Rails ActiveRecord date between
  6. ActiveRecord OR query
  7. How to get a random number in Ruby
  8. ActiveRecord: size vs count
  9. Rails: How can I set default values in ActiveRecord?
  10. Connecting Rails 3.1 with Multiple Databases
  11. How to express a NOT IN query with ActiveRecord/Rails?
  12. ActiveRecord OR query Hash notation
  13. How to chain scope queries with OR instead of AND?
  14. Combine two ActiveRecord::Relation objects
  15. Rails 3: Get Random Record
  16. Rails 5: ActiveRecord OR query
  17. Rails where condition using NOT NIL
  18. Clean way to find ActiveRecord objects by id in the order specified
  19. Rails – Nested includes on Active Records?
  20. ActiveRecord Find By Year, Day or Month on a Date field
  21. Rails 3 SQLite3 Boolean false
  22. Add a reference column migration in Rails 4
  23. Float vs Decimal in ActiveRecord
  24. find vs find_by vs where
  25. query , can not select column count
  26. Can I write PostgreSQL functions on Ruby on Rails?
  27. New data not persisting to Rails array column on Postgres
  28. Validate uniqueness of multiple columns
  29. What is the difference between pluck and collect in Rails?
  30. Changing a column type to longer strings in rails

Leave a Comment