Anyone have an idea on this? Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 6/30/06 2:51:44 PM >>> Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL 4.1.11 Any other suggestions? Thanks again. >>> Dan Nelson < [EMAIL PROTECTED] > 6/30/06 2:48:57 PM >>> In the last episode (Jun 30), Ed Reed said: > Is there a Select statement I can use to get table names so that I > could use other Select statement syntax on the results? > > What I'd like to do is this, > > SHOW Replace(TABLES, 'tbl','') Like 'tbl%'; > > But this doesn't work so I need a Select statement that can do the > same thing. SELECT table_name FROM information_schema.tables; -- Dan Nelson [EMAIL PROTECTED]