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:[EMAIL PROTECTED] >>>Sent: Tuesday, August 22, 2006 2:22 PM >>>To: mysql@lists.mysql.com >>>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/[EMAIL PROTECTED] >>> >>> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
