title: Find the count of EMPTY or NULL columns in a MySQL table
body: <p>I have around 30 columns in a MySQL table.  I want to calculate how many column fields for a particular row are empty. This table is for storing user information.  I want to find out how many profile fields (such as 'Name', 'Age', 'Location' - all of which are stored in a separate column) are empty/haven't been filled in by the user.</p>
  
  <p>The columns I want to refine down are the final 20 columns (because the first 10 columns store stuff like User IDs, passwords, etc. - I only want the final 20 columns which store profile information). How do I find out the AMOUNT of empty/NULL columns in this table?</p>