How to find table using column in MySQL

How to find table using column in MySQL

SELECT *

FROM information_schema.columns

WHERE table_schema = 'schema_name'

AND table_name IN (

    SELECT DISTINCT table_name

    FROM information_schema.columns

    WHERE column_name LIKE '%column_name%'

)

AND column_name LIKE '%column_name%';