RE: [PHP-DB] finding records wiht non-null columns
| From: | Jonathan Hilgeman | Date: | Thu, 03 Jan 2002 16:20:47 +0000 |
| Subject: | RE: [PHP-DB] finding records wiht non-null columns | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15332@lists.php.net to get a copy of this message | ||
...WHERE some_column IS NOT NULL;
- Jonathan
-----Original Message-----
From: bill [mailto:bill@billtron.com]
Sent: Thursday, January 03, 2002 8:19 AM
To: php-db@lists.php.net
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: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net