a little help with a mysql query, please. - GoFuckYourself.com

Mr. Mike · 03-10-2007, 06:01 PM

Is it possible to count the total number of fields in a table that are empty? If so, please let me know, I cant find anything in the manual.

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

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

ooops, nevermind.

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

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

Quote:

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, 06: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

03-10-2007, 06:01 PM	#1
Mr. Mike Confirmed User Join Date: Aug 2004 Posts: 913	a little help with a mysql query, please. Is it possible to count the total number of fields in a table that are empty? If so, please let me know, I cant find anything in the manual. __________________ Sig for sale. ICQ: 163-545-054

03-10-2007, 06:13 PM	#2
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.."

03-10-2007, 06:14 PM	#3
Kaylum Confirmed User Industry Role: Join Date: Aug 2005 Location: Costa Rica Posts: 465	ooops, nevermind. that just returns the number of records with "empty" fields.. not what you wanted. __________________ -- "You can't stop ingenuity, trust me.."

03-10-2007, 06:23 PM	#5
Mr. Mike Confirmed User Join Date: Aug 2004 Posts: 913	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 __________________ Sig for sale. ICQ: 163-545-054