MySQL 以欄位名稱查詢tables

SELECT distinct TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name like 'column_name' and TABLE_SCHEMA = 'DBNAME'

column_name、DBNAME自行替換