title: Check field if empty
body: <p>Is the query correct if I wanted to check if the field has other characters other than null and empty?</p>
  
  <pre><code>select CASE WHEN description IS NULL THEN 'null'
    WHEN description IS NOT NULL THEN 'not null' ELSE 'something else' END 
    AS 'description'from milestone where name like '%Test%' or name like '%test%';
  
  +-------------+
  | description |
  +-------------+
  | not null    |
  +-------------+
  1 row in set (0.00 sec)
  </code></pre>