pguardiario
Reputation: 54984
active record where method and not
I can't seem to find the answer to this anywhere. I know I can do:
Item.where(:color => 'red')
to get all red items, but how do I get all items whose color is not red?
Upvotes: 3
Views: 111
Answers (1)
Jesse Wolgamott
Reputation: 40277
It's a mix of the old school format and the new Arel format.
Item.where("color != ?", 'red')
Upvotes: 5
Related Questions
- Using method in a where clause Rails Ruby Active Record
- Rails Active Record Omitting Where Clause
- Active Record OR query in Rails 4
- In Rails how to use a model's method for the active record `where`?
- active record where {}
- using WHERE clause in Rails 3 active record query
- where conditions on active record rails 3
- .find or where condition in active record querying
- ActiveRecord where method
- class method on active records query