Rails - Dec 2005 - How to allow user entered wildcards in find?

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.


-- 
Posted via http://www.ruby-forum.com/.

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?


Rick Williams wrote:
> 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.