Simple MYSQL Syntax Question

[Kudose]

What would make this correct syntax?

$q = mysql_query("SELECT * FROM customers WHERE coname NOT NULL") or die(mysql_error());

THANKS!

[planetsim]

$q = mysql_query("SELECT * FROM customers WHERE coname != ''") or die(mysql_error());

try that

[milko]

Try "SELECT * FROM customers WHERE coname IS NOT NULL". I think it requires the "IS".