View Single Post
Old 03-10-2007, 06:16 PM  
Mr. Mike
Confirmed User
 
Join Date: Aug 2004
Posts: 913
Quote:
Originally Posted by Kaylum View Post
yes.

select count(*) from table_name where field1 isNULL and field2 isNULL and ...;

or if the fields are empty as in (they were set empty by code):

select count(*) from table_name where field1 = '' and field2 = '' and ...;

i don't know of any built-in mysql function that will help, due to the fact of varying structure of tables.

peace
Excellent! Thanks a million!
__________________
Sig for sale. ICQ: 163-545-054
Mr. Mike is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote