I am trying to have ActiveRecord do the following:
Select * from myTable where ( ucase(name) like ‘%findname%’ )
But when I do this in:
@resultList = Entity.find(:all, :conditions => [“ucase(name) like ?”,
“%name%”])
I end up with:
SELECT * FROM myTable WHERE ( ucase(name) like ‘%‘findname’%’)
ActiveRecord puts single quotes around both of the wildcards, thus
giving me an SQL Syntax error.
What should I be doing to get this to work?