SHOW TABLE STATUS IN 4.1

[christa]

good day!

I use mysql v4.1.x and, via php script, i want to execute this query:

SHOW TABLE STATUS WHERE Name IN ('mytab', 'anothertab, '1234_tab')

 

But, the syntax that works in 4.1 is:

SHOW TABLE STATUS LIKE 'mytab'

 

How can i check more tables?

[Mchl]

Unless you can find a LIKE pattern for them, you can.

In your example:

SHOW TABLE STATUS LIKE '%tab';

will show all tables that end with 'tab'.

 

Remember, 4.1 is no longer supported. High time to upgrade.