mysql条件选择空全文单元格？

Question

i need write a select query to find the number of rows which have an empty fulltext field but for some reason both:

select count(id) from table where field is null;

and

select count(id) from table where field = "";

don't seem to work!

what else is there?!

Answer 1

select
   count(id)
from
   table
where
   isnull(field);

However, your query with "field is null" should work to (and it does, for me at least).