Case-insensitive search in Rails model

by

You’ll probably have to be more verbose here

name = "Blue Jeans"
model = Product.where('lower(name) = ?', name.downcase).first 
model ||= Product.create(:name => name)

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. Eager load polymorphic
  3. accepts_nested_attributes_for with find_or_create?
  4. ActiveRecord.find(array_of_ids), preserving order
  5. Rails order by results count of has_many association
  6. Using Rails serialize to save hash to database
  7. Setting session timeout in Rails 3
  8. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  9. How to query a model based on attribute of another model which belongs to the first model?
  10. Multiple databases in Rails
  11. Rails: ActiveRecord query based on association value
  12. Rails 3, has_one / has_many with lambda condition
  13. Rails ActiveRecord: Find All Users Except Current User
  14. query , can not select column count
  15. How to use ActiveRecord in a ruby script outside Rails?
  16. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  17. Validate uniqueness of multiple columns
  18. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  19. Using helpers in model: how do I include helper dependencies?
  20. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  21. Rails – Validate Presence Of Association?
  22. Do rails rake tasks provide access to ActiveRecord models?
  23. delete_all vs destroy_all?
  24. Rails 3 migrations: Adding reference column?
  25. Converting an array of objects to ActiveRecord::Relation
  26. how to add records to has_many :through association in rails
  27. How to implement bulk insert in Rails 3
  28. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  29. How do I avoid a race condition in my Rails app?
  30. Rails: Order with nulls last

Leave a Comment