mysql表的模糊查询

查询库下所有的表名

SELECT table_name FROM information_schema.tables WHERE table_schema='库名'

模糊表名查询

SELECT table_name FROM information_schema.tables WHERE table_schema='库名' AND table_name LIKE '表名前缀%'