Wildcard and mysql (find_by_sql)

Rails
1

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 !

2

in order to use the wildcard % you need to use th LIKE statement.

select * from table where column like ‘%’;

3

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