MySQL count all NULL columns

Question

I need to count and return the number of NULL columns in my MySQL query.

SELECT * from posttracks WHERE trackid=100000;

How would I COUNT all NULL columns?

Edit: to be clear, I don't need the number of rows that have null values, I need the number of columns in the row that have NULL values.

Answer 1

If I understand your question correctly:

SELECT ISNULL(col1) + ISNULL(col2) + ... + ISNULL(col16) AS cnt
FROM yourTable
WHERE trackid=100000

Answer 2

SELECT count(*) from posttracks WHERE Col1 is NULL