How to find all the tables in MySQL with specific column names in them?

select  table_schema, table_name, column_name
from INFORMATION_SCHEMA.COLUMNS
where column_name like 'FraUrgente';