Navicat_模糊查询字段对应的表

SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME="xxx";


SELECT table_name, column_name FROM information_schema.columns
 WHERE column_name = "xxx";


SELECT column_name FROM information_schema.columns 
WHERE column_name LIKE "%xxx%" AND table_schema = "XXXxxx";

SELECT column_name FROM information_schema.columns 
WHERE column_name LIKE "%xxx%" AND table_schema = "XXXxxx" 
AND table_name = "XXX";