SELECT
table_name ,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA.TABLES
WHERE
table_schema = '******数据库名称*****'
AND TABLE_COMMENT LIKE '%包含的注释%';
SELECT
table_name ,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA.TABLES
WHERE
table_schema = '******数据库名称*****'
AND TABLE_COMMENT LIKE '%包含的注释%';