查询库下所有的表名
SELECT table_name FROM information_schema.tables WHERE table_schema=‘库名‘
模糊表名查询
SELECT table_name FROM information_schema.tables WHERE table_schema=‘库名‘ AND table_name LIKE ‘表名前缀%‘
mysql表的模糊查询
原文：https://www.cnblogs.com/yangyang2018/p/10769017.html
