Is it possible to pipe wildcard searches into mySQL?

2003-09-03 Thread Dan Anderson
I'm writing a search engine to query a database to my site. I know how to use a WHERE product_name = foo if somebody enters the exact product name, but how could I do something like: WHERE product_name = *foo* so all results containing foo in product name would be returned and not just products

Re: Is it possible to pipe wildcard searches into mySQL?

2003-09-03 Thread Paul DuBois
At 21:26 -0400 9/3/03, Dan Anderson wrote: I'm writing a search engine to query a database to my site. I know how to use a WHERE product_name = foo if somebody enters the exact product name, but how could I do something like: WHERE product_name = *foo* so all results containing foo in product