SELECT * FROM table WHERE some_field IS NOT NULL;
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 25, 2006 2:24 PM
To: mysql@lists.mysql.com
Subject: SELECT and NULL
This my be a dumb question, but I have search the docs without finding the
answer.
What I want is something like:
select * from table where some_field not null;
But this gives me an error. I can do a 'where field is null', so I have
tried
different combination with 'not' etc, but without luck. All I get is an SQL
error.
The default value for some_field is null.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]