title: How to limit SHOW TABLES query
body: <p>I have the following query:</p>
  
  <pre><code>SHOW TABLES LIKE '$prefix%'
  </code></pre>
  
  <p>It works exactly how I want it to, though I need pagination of the results. I tried:</p>
  
  <pre><code>SHOW TABLES LIKE '$prefix%' ORDER BY Comment ASC LIMIT 0, 6
  </code></pre>
  
  <p>I need it to return all the tables with a certain prefix and order them by their comment. I want to have pagination via the LIMIT with 6 results per page.</p>
  
  <p>I'm clearly doing something very wrong. How can this be accomplished?</p>
  
  <p>EDIT: I did look at <a href="https://stackoverflow.com/questions/9782948/how-to-apply-pagination-to-the-result-of-show-tables-query-in-php">this</a>. It didn't work for me.</p>