On Thu, Apr 8, 2010 at 9:33 AM, spacemarc <spacem...@gmail.com> wrote:
> 2010/4/7 Carsten Pedersen <cars...@bitbybit.dk>: > > 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