How to limit SHOW TABLES query
===

I have the following query:

    SHOW TABLES LIKE '$prefix%'
It works exactly how I want it to, though I need pagination of the results. I tried:

    SHOW TABLES LIKE '$prefix%' ORDER BY Comment ASC LIMIT 0, 6
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.

I'm clearly doing something very wrong. How can this be accomplished?

EDIT: I did look at [this][1]. It didn't work for me.


  [1]: http://stackoverflow.com/questions/9782948/how-to-apply-pagination-to-the-result-of-show-tables-query-in-php