Get all tables that have a certain field

select table_name from columns where table_schema = 'mydatabase' and column_name = 'looking_for_this_field';