How to Find Tables that Contain a Specific Column in MySQL Server

Example:

SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('DivisionCode')
AND TABLE_SCHEMA='XXX';

Result: