Thanks for your reply,
I have a query where I select all table names where the table name has PID_1 in i.e.
SHOW TABLES LIKE '%PID_1%';
However there may be cases where I need to search for tables where the table name is PID_1 or PID_2. Do you another way I might be able to do this?
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
Reply-To: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>,<mysql@lists.mysql.com>
Subject: Re: SHOW TABLES Problem
Date: Wed, 2 Feb 2005 13:48:43 +0200
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]
