Select Tables using Wild Cards?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • abhishek1234321
    New Member
    • Jul 2010
    • 18

    #1

    Select Tables using Wild Cards?

    I there any way to select tables using wildcards?
    like for example i have 100 tables in my database with names "1rn08cs001 " "1rn08cs002 "... etc

    now i want a wild card method to select oly the tables from
    1rn08cs001 to 1rn08cs005

    is this the right way
    Code:
    mysql_query("SELECT * FROM REGXP 'some regular expression'"
Working...