select for tables?

Pie-eyed newbie question of the week:

Is there a way to find all tables that have a particular column with a particular value?
Something like "select tablename from * where customer_id='12345'" which, let's pretend, would give a list of all tables which have customer_id as a column and which satisfy customer_id='12345'.

Is this possible? Or do we really have to know all the tables having customer_id and search each of them individually? Received on Mon May 01 2000 - 00:00:00 CDT