Select Tables using Wild Cards?

[abhishek1234321]

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

mysql_query("SELECT * FROM REGXP 'some regular expression'"

[dlite922]

You might want to ask in the MySQL forum.