active record where method and not

activerecord, ruby, ruby-on-rails

Solution

It's a mix of the old school format and the new Arel format.

Item.where("color != ?", 'red')

Problem

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?

Original source