a little help with a mysql query, please.

**Kaylum** · 03-10-2007, 04: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

**Kaylum** · 03-10-2007, 04:14 PM

ooops, nevermind.

that just returns the number of records with "empty" fields.. not what you wanted.

**Mr. Mike** · 03-10-2007, 04:16 PM

Originally posted by Kaylum

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!

**Mr. Mike** · 03-10-2007, 04:23 PM

ah, yeah I just noticed that now. It actually is what I need, but this couints tyhe entire database, enstead of a specific column. I need the blank fields in USERS where id=x

a little help with a mysql query, please.

a little help with a mysql query, please.

Comment

Comment

Comment

Comment