title: How to apply pagination to the result of SHOW TABLES query in PHP
body: <p>I would like to apply pagination to the results of <code>SHOW TABLES FROM DATABASE_NAME</code>.</p>
  
  <p>Tried using the <code>LIMIT</code> keyword but an error is thrown.</p>
  
  <p>By pagination I mean that the result(tables) returned by the query is to be displayed on multiple pages.</p>