Unfortuatenly, there is no way to delete all those tables with one query.
You could do some trickery with information_schema though:
http://stackoverflow.com/questions/1...es-with-prefix
Alternatively you could run a simple script:
PHP Code:
require('./global.php');
$tables = $db->query_read("SHOW TABLES LIKE 'taggregate\_temp\__%'");
while ($table = $db->fetch_row($tables))
{
$db->query_write("DROP TABLE `$table[0]`");
}
No guarantees whatsoever, eg. you should be prepared to have a backup ready if anything goes wrong