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 named only "foo"?
Thanks in Advance, Dan Anderson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]