title: How to count NULL values in MySQL?
body: <p>I want to know how can i find all the values that are NULL in the MySQL database for example I'm trying to display all the users who don't have an average yet. </p>
  
  <p>Here is the MySQL code.</p>
  
  <pre><code>SELECT COUNT(average) as num
  FROM users
  WHERE user_id = '$user_id'
  AND average IS_NULL
  </code></pre>