From: Dan Nelson
Date: June 30 2006 9:48pm
Subject: Re: Show tables replacement
List-Archive: http://lists.mysql.com/mysql/199544
Message-Id: <20060630214857.GA4915@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped