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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to