From: spacemarc
Date: April 8 2010 7:33am
Subject: Re: SHOW TABLE STATUS
List-Archive: http://lists.mysql.com/mysql/221168
Message-Id: <l2qe88b70fc1004080033we05192b7u534c3ebc260b0b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

2010/4/7 Carsten Pedersen <carsten@stripped>:
> AFAIR, MySQL 4.x supports LIKE, e.g.
>
> SHOW TABLE STATUS LIKE 'tab_%'

yes, but if the tables have different names (table1, tab_2, abcd... )
your syntax will not work. How to do?