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=""