Re^2: Mysql: select specific tables

I looked at Show table syntax but that doesn't help very much!!
No I have
SHOW TABLES FROM myDB LIKE '^tables_\d+_\d{4}_\d{2}$'
doesn't return anything...
MySQL uses Perl regexp right ?

Thanks
Luca

Comment on Re^2: Mysql: select specific tables Download Code

Replies are listed 'Best First'.
Re^3: Mysql: select specific tables by kulls (Hermit) on Nov 24, 2005 at 09:00 UTC
yes. you're correct. if you look into pattern matching , they mentioned that, " I believe that what you have in your example is a PERL extension which is not part of the POSIX specification for regular expressions and is not important unless you need to extract the matched substrings (which is not the case)." -kulls	[reply]