title: mysql negation of like doesn't return what expected, why?
body: <p>I have a mysql table that has 2796 entries. I'd like to select entries that doesn't contain the word SUPPR somewhere in the notes field.</p>
  
  <p>If I do the following</p>
  
  <pre><code>SELECT * FROM `catalogues` WHERE notes LIKE "%SUPPR%"
  </code></pre>
  
  <p>It returns 266 row. But if I write what I consider the complement</p>
  
  <pre><code>SELECT * FROM `catalogues` WHERE notes not LIKE "%SUPPR%"
  </code></pre>
  
  <p>it returns 762 rows when I was expecting 2530 (2796-266).</p>
  
  <p>How should I write the second request to get what I need?</p>