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 !
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 !
in order to use the wildcard % you need to use th LIKE statement.
select * from table where column like ‘%’;
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
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.
Sponsor our Newsletter | Privacy Policy | Terms of Service | Remote Ruby Jobs