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
[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
