How to do a LIKE query in Arel and Rails?

by

This is how you perform a like query in arel:

users = User.arel_table
User.where(users[:name].matches("%#{user_name}%"))

PS:

users = User.arel_table
query_string = "%#{params[query]}%"
param_matches_string =  ->(param){ 
  users[param].matches(query_string) 
} 
User.where(param_matches_string.(:name)\
                       .or(param_matches_string.(:description)))

More Related Contents:

  1. How to implement bulk insert in Rails 3
  2. How do I replace accented Latin characters in Ruby?
  3. How to chain scope queries with OR instead of AND?
  4. When to use a “has_many :through” relation in Rails?
  5. Combine two ActiveRecord::Relation objects
  6. Rails 5: ActiveRecord OR query
  7. Ruby on Rails. How do I use the Active Record .build method in a :belongs to relationship?
  8. Alias for column names in Rails
  9. What does inverse_of do? What SQL does it generate?
  10. ActiveRecord Find By Year, Day or Month on a Date field
  11. Rails 3 devise, current_user is not accessible in a Model ?
  12. How to query a model based on attribute of another model which belongs to the first model?
  13. LEFT OUTER joins in Rails 3
  14. How does Rails ActiveRecord chain “where” clauses without multiple queries?
  15. How to test for (ActiveRecord) object equality
  16. How to execute a raw update sql with dynamic binding in rails
  17. Bulk Insert records into Active Record table
  18. What’s the difference between belongs_to and has_one?
  19. Regular expressions with validations in RoR 4
  20. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  21. Do rails rake tasks provide access to ActiveRecord models?
  22. how to add records to has_many :through association in rails
  23. How to use long id in Rails applications?
  24. Rails 3.1 limit user created objects
  25. Is there a way to avoid automatically updating Rails timestamp fields?
  26. Non persistent ActiveRecord model attributes
  27. Rails gem rails3-jquery-autocomplete: How do I query multiple fields
  28. Rails best way to get previous and next active record object
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Rails Object Relationships and JSON Rendering

Leave a Comment