ActiveRecord OR query

by

If you want to use an OR operator on one column’s value, you can pass an array to .where and ActiveRecord will use IN(value,other_value):

Model.where(:column => ["value", "other_value"]

outputs:

SELECT `table_name`.* FROM `table_name` WHERE `table_name`.`column` IN ('value', 'other_value')

This should achieve the equivalent of an OR on a single column

More Related Contents:

  1. ActiveRecord: size vs count
  2. Connecting Rails 3.1 with Multiple Databases
  3. How to chain scope queries with OR instead of AND?
  4. ActiveRecord Find By Year, Day or Month on a Date field
  5. Rails 3 SQLite3 Boolean false
  6. Rails update_attributes without save?
  7. Validate uniqueness of multiple columns
  8. Format a string containing Phone numbers
  9. Best way to load module/class from lib folder in Rails 3?
  10. Eager load polymorphic
  11. Rails order by results count of has_many association
  12. Add a reference column migration in Rails 4
  13. Why doesn’t `config.time_zone` seem to do anything?
  14. query , can not select column count
  15. Setting Environment Variables in Rails 3 (Devise + Omniauth)
  16. Using Rails link_to for links that post
  17. Can we call a Controller’s method from a view (as we call from helper ideally)?
  18. Use rvmrc or ruby-version file to set a project gemset with RVM?
  19. How to change the default path of view files in a Rails 3 controller?
  20. Why use “self” to access ActiveRecord/Rails model properties?
  21. Rails has_many through form with checkboxes and extra field in the join model
  22. Changing the base URL for Rails 3 development
  23. Is it possible to refresh partial frequently using Ajax?
  24. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  25. Changing a column type to longer strings in rails
  26. Controlling the order of rails validations
  27. Ruby on Rails 3 howto make ‘OR’ condition
  28. Adding foreign key to a rails model
  29. Rails catch-all/globbing routes
  30. Always getting 401 Unauthorized with new install of Rails + Devise

Leave a Comment