GoFuckYourself.com - Adult Webmaster Forum - View Single Post - a little help with a mysql query, please.

Kaylum · 03-10-2007, 06:13 PM

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

03-10-2007, 06:13 PM
Kaylum Confirmed User Industry Role: Join Date: Aug 2005 Location: Costa Rica Posts: 465	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 __________________ -- "You can't stop ingenuity, trust me.."