ActiveRecord OR query

ruby-on-rails ruby-on-rails-3 rails-activerecord
pho3nixf1re picture pho3nixf1re · Sep 3, 2010 · Viewed 136.1k times · Source

How do you do an OR query in Rails 3 ActiveRecord. All the examples I find just have AND queries.

Edit: OR method is available since Rails 5. See ActiveRecord::QueryMethods

Answer

deadkarma picture deadkarma · Mar 1, 2012

If you want to use an OR operator on one column's value, you can pass an array to .where and ActiveRecord will use IN(value,other_value):

Model.where(:column => ["value", "other_value"]

outputs:

SELECT `table_name`.* FROM `table_name` WHERE `table_name`.`column` IN ('value', 'other_value')

This should achieve the equivalent of an OR on a single column

Related questions

Rails update_attributes without save?

Is there an alternative to update_attributes that does not save the record? So I could do something like: @car = Car.new(:make => 'GMC') #other processing @car.update_attributes(:model => 'Sierra', :year => "2012", :looks => "Super Sexy, wanna …

Read More
ActiveRecord find and only return selected columns

edit 2 If you stumble across this, check both answers as I'd now use pluck for this I have a fairly large custom dataset that I'd like to return to be echoe'd out as json. One part is: l=Location.find(…

Read More
How to chain scope queries with OR instead of AND?

I'm using Rails3, ActiveRecord Just wondering how can I chain the scopes with OR statements rather than AND. e.g. Person.where(:name => "John").where(:lastname => "Smith") That normally returns: name = 'John' AND lastname = 'Smith' but I'd like: `…

Read More