thank you, this makes sense. On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson <dnel...@allantgroup.com> wrote: > 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 > dnel...@allantgroup.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=nor...@khine.net > >
-- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ %>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org