MySQL Database Check How Many Table Have Column Match Query

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'COLUMN_NAME_TYPE_HERE'
  AND TABLE_SCHEMA = 'DATABASE_NAME_TYPE_HERE';