pagination - 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?

question from:https://stackoverflow.com/questions/3407620/only-show-tables-with-certain-patterns-in-mysql-show-tables

Answer 1

show tables like 'pattern';