Well considering that you are searching for the text 'NULL' and not a null
value
haveyou tried " level2 is null" ?
:-)
- Original Message -
From: "Ward, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 IS NULL;
IS NULL instead of = "NULL"
null is not a value, it's the abscence of value
Etienne
"Ward, Mark" wrote:
>
> I don't know how this affects anything, but, I'm running the most recent
> version of mySQL for win98.
>
> Why is
I don't know how this affects anything, but, I'm running the most recent
version of mySQL for win98.
Why is it that an SQL statement like this (or any variation)...
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 = "NULL";
will return an empty set. I know that there should be resul