How to make keywords filtering queries in Rails 3?

Question

class SearchController < ApplicationController
  def autocomplete
    @location=Location.find_by_sql("select * from locations where name like ?;",['%'+params[:term]+'%'])
    render  json: @location
  end
end

I think query like this is not working as expected: select * from locations where name like '%XXXX%';

Neither can I wrote code like this: @location=Location.find_by_sql("select * from locations where name like '?';", the function will fail to recognize the params

So how could I implement such keywords filtering queries?

Possible duplicate of http://stackoverflow.com/questions/4430578/how-to-do-a-like-query-in-arel-and-rails-3 — Ernest, Mar 23 '12 at 11:02

score 0 · Accepted Answer · answered Mar 23 '12 at 10:50

0

This should work:

@location = Location.where("name LIKE ?", "%#{params[:term]}%")

answered Mar 23 '12 at 10:50

Dogbert

212,659
41
396
397

How to make keywords filtering queries in Rails 3?

1 Answers1