Rails 3: Is there an "AR # or_where"?

Question

Is there AR#or_where in Rails 3, as in

 User.where(cond1).or_where(cond2) 

?

Answer 1

There is no such method in Rails.

I think the easiest way to do OR in a WHERE clause is to do something like this:

 User.where("first_name = ? OR last_name = ?", params[:first_name], "Wilson") 

If you want to learn about Arel methods (which has an “or” method), look here: https://github.com/rails/arel#readme . Using Arel and ActiveRecord, you can do the same:

 User.where(User.arel_table[:first_name].eq(params[:first_name]).or(User.arel_table[:last_name].eq('Wilson'))) 

Answer 2

You can look at meta_where . This pearl allows you to use the more powerful ActiveRecord query expressions in Ruby code without requiring you to drop SQL fragments.

Answer 3

Just using User.where(cond1) | User.where(cond2) User.where(cond1) | User.where(cond2) , || reserved by ruby!

Answer 4

If you want to link them like this, you need to dig into isl a bit. See this similar SO question .