MySQLでテーブル名を検索する

> mysql -h=xxx -u=username -p=**** dbname
 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 290
Server version: 5.1.36-community MySQL Community Server (GPL)
 
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
 
mysql> SHOW TABLES like 'wp_%';
+-----------------------+
| Tables_in_bgcom (wp_%)|
+-----------------------+
| wp2_blog_off_comments           |
| wp2_blog_off_links              |
| wp2_blog_off_options            |
| wp2_blog_off_postmeta           |
| wp2_blog_off_posts              |
| wp2_blog_off_term_relationships |
| wp2_blog_off_term_taxonomy      |
| wp2_blog_off_terms              |
| wp2_blog_off_usermeta           |
| wp2_blog_off_users              |
+-----------------------+
13 rows in set (0.01 sec)
 
mysql>