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?
pages = Page.find(:all, :conditions => "name like 'Wiki%'")
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.