From: Dan Nelson
Date: July 29 2010 9:29pm
Subject: Re: IS NULL returns Empty set, but I have empty items
List-Archive: http://lists.mysql.com/mysql/222373
Message-Id: <20100729212912.GA58235@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 29), Norman Khine said:
> I don't know what I am missing, but I have this:
> 
> mysql> SELECT url FROM product WHERE url IS NULL;
> Empty set (0.05 sec)
> 
> mysql> SELECT url FROM product WHERE product_Id = 67;
> +------+
> | url  |
> +------+
> |      |
> +------+
> 1 row in set (0.00 sec)
> 
> what goes with this, how can i ensure that this is NULL?

Your url may be the empty string "".  If it was really NULL, you would see
"NULL" in the resultset.  Try

SELECT * FROM product WHERE url=""

-- 
	Dan Nelson
	dnelson@stripped