Find_by_sql prepared statements with like

Rails
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

On Dec 16, 2007 9:07 AM, jmark [email protected] wrote:

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])

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