Deleting tableprefix_* tables?


#1

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?

Thanks


#2

Maybe the MySQL keyword LIKE with wildcards…

http://dev.mysql.com/doc/mysql/en/Strin … tions.html