Ja Bo wrote:
Somehow I can not get the wildcard character "%" to work when using a MySQL find_by_sql statement... As soon as I remove the % character everything works... Is there a workaround, another character to be used ?
Thank you very much !
Do you have to drop down to find_by_sql, or can you use a normal find?
Example:
pages = Page.find(:all, :conditions => "name like 'Wiki%'")
or
prefix = 'Wiki' pages = Page.find(:all, :conditions => ['name like ?', prefix + '%'])
The key thing is that you need to put the % in the argument you are supplying, because when Rails does substitution into the placeholder (?) it will be doing escaping and quoting for you.
regards
Justin