cool tag line goes here...

select table_name from information_schema.columns where column_name in ('column1','column2') and table_schema='yourdatabase';