id AND
company_name regexp '#FORM.query#' AND
product_name regexp '#FORM.query#' AND
description regexp '#FORM.query#'
Also what about indexes?
Thanks in advance for your help.
Nathan
On Fri, 22 Aug 2003 23:28:18 +
"Nathan Simms"
Hi, I'm currently using the following mysql statement to perform a search.
Right now it is only returning the results which are found in the
description field. How do I modify this statement so that it is searching
the following fields: company_name, product_name, description.
SELECT product_id,
