Multiple where conditions in Rails

Question

I'm implementing a user search feature in my Rails app. However, I don't want admins to appear in the search results.

I'm trying this:

User.where(:admin => [nil, false], ["name LIKE ?", "%#{params[:query]}%"])

But I get this error:

syntax error, unexpected ')', expecting tASSOC

So how do I properly list where clauses inside the parentheses?

Answer 1

Try this

User.where(["name LIKE ?", "%#{params[:query]}%"]).where(:admin => [nil, false])