I’m trying to implement a simple search box:
@items = Item.find(:all, :conditions => [“description like %?% or text
like %?%”, @search_text, @search_text])
The problem with this is rails automatically encloses the search term in
single quotes, resulting in this MySQL error:
Mysql::Error: #42000You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ‘%‘stuff’% or text like %‘stuff’%)’ at line 1: SELECT
- FROM items WHERE (description like %‘stuff’% or text like %‘stuff’%)
Is there a simple (not necessarily elegant) way to fix this?
Thanks a lot!!!