Detect empty fields

I need to detect empty fields inside a table. I would like to know if it is possible to generate a query that gives me this information as a result and how I should do it

Can you give an example of the table and what you are trying to do?
Because I think it would be (in Mysql) as simple as this:
select sum(case when column is null then 1 else 0 end) from table