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
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.
