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. It didn't work for me.