only show tables with certain patterns in mysql "show tables"

Question

there are too many tables in a db. how can I only show tables with certain patterns? or is there a way I can do paging like "| more" in shell command

Answer 1

You don't have to use show tables, you can also query information_schema.TABLES using any filter.

Answer 2

show tables like 'pattern';