Hello P.Peti,
Monday, March 12, 2001, 11:17:16 PM, you wrote:
PP> It just seems to be weird that a subset and its complement
PP> does not equal the whole table. So the thing is:
PP> #"!deleted" doesn't include "#NULL" as the set filtered by
PP> the clause 'WHERE comment!="deleted"' doesn't include NULL
PP> value comments. This is what I don't understand.
NULL is NULL. You can't check it by comparison, the only way to get
null is to use IS NULL. It is important to understand what NULL values
ara and how to deal with them in SQL.
Regards,
ic
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
