Deleting all templates with a certain prefix?

[Link14716]

Say I want to delete all templates with the rpg_ prefix. It would take far too long to delete each one manually, so how could I easily delete them all at the same time?

[GSHelpBoy]

I think something like this would work:

PHP Code:

$sql = "DELETE FROM `table` WHERE `name` LIKE 'rpg_%'"; 

But don't quote me on it.

[Link14716]

I'll try it, thanks