simple search for column name all tables in db

select *
from information_schema.columns
where column_name like '%column_name%'