Please note that "" (empty string) and NULL is not the same value.
The following query will return records where x is not null:
SELECT * FROM db WHERE x IS NOT NULL;
But since "" and NULL is different values, it might just as well return
empty strings.
If you want records where x actually co
Jonathan Hilgeman [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 03, 2002 11:21 AM
> To: 'bill'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: [PHP-DB] finding records wiht non-null columns
>
> ...WHERE some_column IS NOT NULL;
>
> - Jonathan
>
...WHERE some_column IS NOT NULL;
- Jonathan
-Original Message-
From: bill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 8:19 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] finding records wiht non-null columns
Is there a better query than
SELECT *
FROM some_database
WHERE s
