Query database Specifies whether all tables in the database contain the specified fields

Today encountered a problem is to bulk update the value of a field in the database, you need to find out which table contains this field, organized the following statement to facilitate query

SELECT DISTINCT
T.table_name,
C.column_name
From
Information_schema. TABLES T
INNER JOIN information_schema. COLUMNS C
On c.table_name = T.table_name
where T.table_type = ' base TABLE '
and c.column_name = ' field name '
and T.table_schema = ' database name '
ORDER by T.table_type

This statement queries the table name + field name and then determines which table needs to be updated how to update

Query database Specifies whether all tables in the database contain the specified fields