mysql查找数据中包含特定字符的字段名所在的表

在整个MySQL数据库中查找

select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like "%placement%";

在特定数据库中查找

SELECT DISTINCT TABLE_NAME  FROM INFORMATION_SCHEMA.COLUMNS  WHERE COLUMN_NAME IN ("ColumnA","ColumnB") AND TABLE_SCHEMA="DatabaseName";

SELECT DISTINCT TABLE_NAME  FROM INFORMATION_SCHEMA.COLUMNS  WHERE COLUMN_NAME LIKE "%ColumnA%" AND TABLE_SCHEMA="DatabaseName";

在特定数据库中查找包含A和B字段的表

SELECT DISTINCT *  FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ("A") and  TABLE_NAME in
(SELECT DISTINCT TABLE_NAME  FROM INFORMATION_SCHEMA.COLUMNS  WHERE COLUMN_NAME IN ("B")  AND TABLE_SCHEMA="DatabaseName")