CODEWITHSUNDEEP
ruby-on-railsrubyactiverecordrails-activerecord
XåpplI'-I0llwlg'I -
XåpplI'-I0llwlg'I -

Reputation: 22404

Multiple where conditions in Rails

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?

Upvotes: 25

Views: 37684

Answers (1)

Ismael
Ismael

Reputation: 16720

Try this

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

Upvotes: 52

Related Questions