in reply to Mysql: select specific tables

Hi,
I guess u missed the database name in the query. check the sytanx here
-kulls

Replies are listed 'Best First'.
Re^2: Mysql: select specific tables
by jeanluca (Deacon) on Nov 24, 2005 at 08:44 UTC
    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
[reply]
[d/l]
      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]

In Section Seekers of Perl Wisdom