查询mysql包含某个字段的所有表

show  tables  like 'crm_%'

mysql根据字段查表名

SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE 'Name';

SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’

SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’ AND table_name = ‘yourDBTable’