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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]