user398384 user398384 - 1 year ago 87
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 Source
show tables like 'pattern';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download