SELECT
a.TABLE_NAME,b.TABLE_COMMENT,a.COLUMN_NAME,a.COLUMN_TYPE,a.COLUMN_COMMENT
FROM
information_schema.COLUMNS a
JOIN information_schema.TABLES b ON a.TABLE_SCHEMA = b.TABLE_SCHEMA
AND a.TABLE_NAME = b.TABLE_NAME
WHERE
a.TABLE_NAME LIKE 'lm_%'
ps:大的列通过MD5编码后对MD5查询