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 same as another.
Or, in other words, always include "IS NULL" if you expect NULL values to be returned in your >> QUERY << :) ; SELECT * FROM Users WHERE Password LIKE "%password%" OR Password IS NULL;
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
