title: mysql not like does not work
body: <p>I have a problem with mysql select using "not like" in where conditions. There are 15k records in table. 3k records are with value 'test' in column col1.</p>
  
  <p>This select works fine:</p>
  
  <pre><code>select 
      *
  from
      `table`
  where
      `col1` like 'test'
  </code></pre>
  
  <p>3000 rows selected. This is correct.</p>
  
  <p>But if I try this select:</p>
  
  <pre><code>select
     *
  from
     `table`
  where
     `col1` not like 'test'
  </code></pre>
  
  <p>0 rows selected while I expect 12000 rows.</p>
  
  <p>I will be grateful for any ideas?</p>