Because it does not know REGEXP... only LIKE patterns...
% Matches any number of characters, even zero characters
_ Matches exactly one character
Taake a look in chapter 13 "String Comparison Functions".
Gabriel PREDA
----- Original Message -----
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, February 02, 2005 1:03 PM
Subject: SHOW TABLES Problem
> 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
