Multiple where conditions in Rails

activerecord, rails-activerecord, ruby, ruby-on-rails

Solution

Try this

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

Problem

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?

Original source