List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 29 2010 9:29pm
Subject:Re: IS NULL returns Empty set, but I have empty items
View as plain text  
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
Thread
IS NULL returns Empty set, but I have empty itemsNorman Khine29 Jul
  • Re: IS NULL returns Empty set, but I have empty itemsAndy Wallace29 Jul
  • Re: IS NULL returns Empty set, but I have empty itemsDan Nelson29 Jul
    • Re: IS NULL returns Empty set, but I have empty itemsNorman Khine30 Jul