At 22:58 +0200 10/27/04, Luke Venediger wrote:
Hi,
I'm trying to do the following:
SELECT
IF((ProductStatus IS NOT NULL), "Available", "Not Available") as
ProductStatus
FROM
tb_Product
WHERE
ProductName = "MyProduct";
It works fine if the ProductName "MyProduct" works, and returns
"Available". However, if the product name doesn't work the query
doesn't return any rows. I would like it to return "Not Available" if
the product isn't found.
Is there a better way to do this?
SELECT IF(COUNT(*),"Available","Not Available") As ProductStatus
FROM
tb_Product
WHERE
ProductName = "MyProduct";
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]