title: Exclude records with empty binary column data
body: <p>I have a column with type <code>binary(16) not null</code> in a mysql table. Not all records have data in this column, but because it setup to disallow <code>NULL</code> such records have an all-zero value.</p>
  
  <p>I want to exclude these all-zero records from a query.</p>
  
  <p>So far, the only solution I can find is to <code>HEX</code> the value and compare that:</p>
  
  <pre><code>SELECT uuid
  FROM example
  WHERE HEX(uuid) != '00000000000000000000000000000000'
  </code></pre>
  
  <p>which works, but is there a better way?</p>