From: Johan De Meersman Date: April 8 2010 10:36am Subject: Re: SHOW TABLE STATUS List-Archive: http://lists.mysql.com/mysql/221175 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016362852fefbd90a0483b7414c --0016362852fefbd90a0483b7414c Content-Type: text/plain; charset=ISO-8859-1 On Thu, Apr 8, 2010 at 9:33 AM, spacemarc wrote: > 2010/4/7 Carsten Pedersen : > > 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? > Multiple statements. Remember, "show table status" is not SQL, it's a command to the mysql server. Regular SQL constructs do not apply. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016362852fefbd90a0483b7414c--