Love it when that happens :)
Fastest way I can think of is dumping out the structure of the database
with mysqldump -d > database.sql
and then searching the output to see where those columns appear
>>>-----Original Message-----
>>>From: Jerry Schwartz [mailto:jschwartz@stripped]
>>>Sent: Tuesday, August 22, 2006 2:22 PM
>>>To: mysql@stripped
>>>Subject: Finding field in all tables
>>>
>>>Is there any way to find a column name (or, better yet, a
>>>partial column
>>>name) in all tables within a data base?
>>>
>>>I inherited a complex and totally undocumented data base,
>>>and need to find
>>>out (for example) which tables have a column name like xxx_exported.
>>>
>>>
>>>Regards,
>>>
>>>Jerry Schwartz
>>>Global Information Incorporated
>>>195 Farmington Ave.
>>>Farmington, CT 06032
>>>
>>>860.674.8796 / FAX: 860.674.8341
>>>
>>>
>>>
>>>
>>>--
>>>MySQL General Mailing List
>>>For list archives: http://lists.mysql.com/mysql
>>>To unsubscribe:
>>>http://lists.mysql.com/mysql?unsub=1
>>>
>>>
