Re: SHOW TABLE STATUS

[Carsten Pedersen]

AFAIR, MySQL 4.x supports LIKE, e.g.

SHOW TABLE STATUS LIKE 'tab_%'

/ Carsten

spacemarc skrev:
> hi all,
> in MySQL 4.1.x i want to obtain the status of more tables with one only query.
> 
> In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')"
> 
> In 4.1.x i tried to use but it doesn't works: how to set the query?
> 
> Thanks
>