thank_you
Reputation: 11107
Where Clause with OR in Rails
How do I write a where clause where I have a where argument that can take multiple options. For example,
User.where(name: "Jason" OR name: "Bob")
Although I know that isn't the correct syntax, what is?
Upvotes: 0
Views: 254
Answers (2)
tobinjim
Reputation: 1852
I'm always late to the party...
friends = User.where(:name => ["Jason", "Bob"])
(Rails 4.0.0)
Upvotes: 0
Chowlett
Reputation: 46667
While I don't have a console to hand to check, I'm pretty sure it's:
User.where(name: ["Jason", "Bob"])
Upvotes: 3
Related Questions
- Where with OR condition for the same column in Rails
- OR operator inside a Where Active Record Query
- Building a where and or query in rails 4
- Rails - Writing a Where Query With an Or Clause
- How to use OR condition in ActiveRecord query
- multiple where statements combined with OR in Activerecord and Ruby
- How To Use OR Operator In Where Condition-Rails ActiveRecord
- Rails ActiveRecord where or clause
- Rails Active Record query -- 'or' conditions
- OR operators and Ruby where clause