find_by_sql prepared statements with like

rubyonrails-talk
1

How does one write a prepared statement with LIKE using find_by_sql.

For example the problem with soemthing like this is that extra quotes are put around the ? Product.find_by_sql(["SELECT * FROM products WHERE name LIKE '%?%'"], params[:name])

Thanks John

2

Perhaps you could try Product.find_by_sql(["SELECT * FROM products WHERE name LIKE ?"], "%#{params[:name]}%")

Not positive it'll work though.

Pat

3

Thank you Pat. Your solution worked