IS NOT NULL?

[Anon]

In MySQL, what is the syntax for a query asking for everything from a tables EXECPT where a specific field has a null value?

I tried this but it brings back the null records too:

SELECT * FROM table WHERE field IS NOT NULL;

whats the correct way to do it?

[terje-s]

SELECT * FROM table WHERE NOT isnull(field);

Be aware of the differences between '', 0 and NULL.

[Anon]

Another way you can do it is this

Select * from table where firled!="";

Di

[Anon]

oops...

I meant

<b>SELECT * FROM table WHERE field!="";</b>

Di