通过注释查找字段和表名

SELECT COLUMN_NAME,column_comment,Table_NAME FROM INFORMATION_SCHEMA.Columns WHERE  table_schema='数据库名' AND column_comment LIKE '%代课%';