mysql中查询条件字段为空的查询

如：SELECT NO FROM goodstype WHERE parentType = NULL ORDER BY NO DESC LIMIT 0,1

语句上没错，但查询结果为空。

正确的写法是这样：SELECT NO FROM goodstype WHERE parentType is NULL ORDER BY NO DESC LIMIT 0,1