user398384 user398384 - 1 month ago 9
MySQL Question

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

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
show tables like 'pattern';