title: mysql: What is the right syntax for NOT LIKE?
body: <p>Hi I am trying to show tables with names not like a pattern by mysql is throws an error:</p>
  
  <pre><code>SHOW TABLES  NOT LIKE  "tree%";
  </code></pre>
  
  <p>returns:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT LIKE "tree%"' at line 1
  </code></pre>
  
  <p>What is the right syntax?</p>
  
  <p>Thanks Arman.</p>