Paul DuBois wrote:
That makes perfect sense. That value of NULL is unknown, so it's
impossible to say whether or not it matches a pattern. The only
reasonable result is NULL. Even NULL LIKE NULL and NULL REGEXP NULL
return NULL, because you can't tell whether or not one unknown value
is the s
In the last episode (Nov 02), Kevin McManus said:
> >Description:
> The WHERE statement does not correctly return rows matching NULL
> fields when using NOT with IN, LIKE or REGEXP - or using REGEXP
> with negation ^
Please see http://www.mysql.com/doc/en/Working_with_NULL.html
At 5:21 + 11/2/02, Kevin McManus wrote:
Date: Sat, 2 Nov 2002 05:09:44 +
From: Kevin McManus <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: behaviour of WHERE statement with NULL fields
User-Agent: Mutt/1.4i
Description:
The WHERE statement does not correctly return rows mat
