SHOW TABLES Problem

[shaun thornburgh]

Hi,

The syntax for show tables from the manual is:

SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern']

so whay doesnt the following query work:

SHOW TABLES LIKE REGEXP 'PID_[0-9]+';

Thanks for your help

Shaun

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]