title: like and not like in one mysql query
body: <p>I want to do a query containing 'like' and 'not like'.</p>
  
  <p>Current example: i want everything starting with '1|%' but not with '1|6|199|%' or '1|6|200|%'.</p>
  
  <p>Current query: </p>
  
  <pre><code>'SELECT * FROM `links` WHERE `category` LIKE '1|%' NOT LIKE '1|6|199|%','1|6|200|%' ORDER BY `score` DESC LIMIT 9'.
  </code></pre>
  
  <p>But that doesn't work. Any tips? thx</p>