> -----Original Message-----
> From: Nathan Simms [mailto:[EMAIL PROTECTED]
> The problem is that I need my statement to search the
> product_name and
> description fields as well. However when I add them to my
> statement, it
> doesn't work???
> The statment below does not work:
>
> SELECT product_id, company_name, product_name, url, description
> FROM product, company
> WHERE product.product_id = company.company_id AND
> company_name regexp '#FORM.query#' AND
> product_name regexp '#FORM.query#' AND
> description regexp '#FORM.query#'
Your 'AND' logic is faulty. Try:
SELECT product_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND
( company_name regexp '#FORM.query#' OR
product_name regexp '#FORM.query#' OR
description regexp '#FORM.query#' )
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
