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]