title: MySQL: WHERE status NOT LIKE 'example%' isn't returning results with NULL status
body: <p>I have a table that looks like the following:</p>
  
  <pre><code>+---------+----------+-----------------+
  | name    |   age    | status          |
  +---------+----------+-----------------+
  | Clark   |   25     | Example         |
  +---------+----------+-----------------+
  | Peter   |   28     | Example2        |
  +---------+----------+-----------------+
  | Waldo   |   37     | NULL            |
  +---------+----------+-----------------+
  | Tarzan  |   31     | Unknown         |
  +---------+----------+-----------------+
  </code></pre>
  
  <p>When I perform a query like so:</p>
  
  <pre><code>SELECT * FROM records WHERE status NOT LIKE 'example%'
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>+---------+----------+-----------------+
  | name    |   age    | status          |
  +---------+----------+-----------------+
  | Tarzan  |   31     | Unknown         |
  +---------+----------+-----------------+
  </code></pre>
  
  <p>If I change the query to (notice that <strong>I removed the <code>NOT</code></strong>):</p>
  
  <pre><code>SELECT * FROM records WHERE status LIKE 'example%'
  </code></pre>
  
  <p>I then get the following:</p>
  
  <pre><code>+---------+----------+-----------------+
  | name    |   age    | status          |
  +---------+----------+-----------------+
  | Clark   |   25     | Example         |
  +---------+----------+-----------------+
  | Peter   |   28     | Example2        |
  +---------+----------+-----------------+
  </code></pre>
  
  <p>My question is: <strong>where's Waldo?</strong></p>