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
If you want records where x actually contains something, i.e. neither NULL
og an empty string, the following should work fine:
SELECT * FROM db WHERE x <> "";
> -----Original Message-----
> From: bill [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 03, 2002 5:19 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] finding records wiht non-null columns
> Is there a better query than
> SELECT *
> FROM some_database
> WHERE some_column <> ""
> I had tried
> WHERE some_column <> NULL but that didn't work.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]