Searching multiple fields with conditions

I am very new at RoR but am trying to tweak the code for the AJAX table

I have it all working the way I want except for one line of code:

conditions = ["firstname LIKE ?" , "%#{@params[:query]}%"] unless

I need this to look at multiple fields not just firstname. Any idea how
I do this?

unless params[:query].blank?
   query = "%#{@params[:query]}%"
   conditions = ["firstname LIKE ? OR lastname LIKE ?", query, query]

You can add as many OR's as you want as long as you keep adding more query's to the end.

Your database may not like you if you do this, but that's another matter :slight_smile: