Oh, sorry about that. I think I read it a bit too quickly... You can't that I'm aware of, besides getting the table list and using an external script to loop through them.
But, of course, I definitely could be wrong. Chris -----Original Message----- From: Patricia LaRue [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: RE: Searching all db tables for a column name in MySQL - how? can I? Chris: Your syntax and all documented syntax is for querying column names in just one table. My question is "How do I search for a specific column name in ALL tables? Chris <[EMAIL PROTECTED]> wrote: SHOW COLUMNS FROM table_name LIKE 'Identifier'; should work. It's all in here, jsut search the page for SHOW COLUMNS: http://www.mysql.com/doc/en/Show_database_info.html Chris -----Original Message----- From: Patricia LaRue [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:02 AM To: [EMAIL PROTECTED] Subject: Searching all db tables for a column name in MySQL - how? can I? In Oracle it looks like this: SELECT table_name FROM all_tables WHERE column_name = 'Identifier' Does anybody know if this is possible in MySQL and if so, what's the syntax? I can't find anything in the documentation that allows me to search for a specific column in all tables. Thank you, Patricia Patricia's Fancy Visit my eBay store for great deals on terrific items! I specialize in pretty things for the girl inside of women and boy toys for the boy inside of men, but also have a variety of life's little necessities. If you play music, check out Rainbow Music Outlet. Bookmark these stores as we are always adding new merchandise for your shopping pleasure. --------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Patricia's Fancy Visit my eBay store for great deals on terrific items! I specialize in pretty things for the girl inside of women and boy toys for the boy inside of men, but also have a variety of life's little necessities. If you play music, check out Rainbow Music Outlet. Bookmark these stores as we are always adding new merchandise for your shopping pleasure. --------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
