Deleting tableprefix_* tables?


Hi, i need to find a way to do a mysql_query with php, it should delete every table with the table prefix specified, so like if i had tables prefix_1 prefix_2 prefix_x it would delete every one of them.

So basically it would be prefix_* but this does not work.
Any suggestions?



Maybe the MySQL keyword LIKE with wildcards… … tions.html