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]
