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]