How to search tables by column name

select table_name, column_name from information_schema.columns where column_name like ‘%column_name%’;