How to allow user entered wildcards in find?


#1

Anyone know how to allow user entered (mySql) wildcards for a find?

It seems that if I do a plain find(:all… with % as the search text it
finds nothing where it seems it should find every row.

I hope this is stated clearly enough.


#2

this worked for me when I gave an arg of “%” and “%ev%”:

conditions = [ "name like ?", args[0] ]
MyTable.find( :all, :conditions => conditions ).each { |e| puts 

e[:name]}

or are you referring to MySQL regular expression search?