mysql condition to select empty fulltext cell?

Posted by significance on Stack Overflow See other posts from Stack Overflow or by significance
Published on 2010-04-23T10:53:30Z Indexed on 2010/04/23 11:13 UTC
Read the original article Hit count: 168

Filed under:
|
|

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?!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php