title: Exclude tables in show tables like statement in MySQL
body: <p>In <code>MySQL</code> database I have some tables which end with <code>_history</code>.</p>
  
  <p>Now I want to select tables that are like <code>_history</code>.</p>
  
  <p>I have done like below.</p>
  
  <pre><code>show tables like '%_history`
  </code></pre>
  
  <p>Now I got the desired result. </p>
  
  <p>Now in this result I got some tables which start with <code>temp</code>. Ex: <code>temp_102_history</code>.</p>
  
  <p>Is there a way to exclude the tables that start with <code>temp</code> in the <code>show tables like '%_history</code> statement.</p>