MySql查询多表标题

SELECT 
  TABLE_NAME
FROM
  INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'XXX'
AND TABLE_NAME LIKE 'tbl_%_project_info'
GROUP BY TABLE_NAME

 

其中XXX为库名

 

 

tbl_%_project_info 表示查出类似这个名字的表