Mass Delete Users (PLEASE MAKE)

[Nkay]

Hello,

Today my forum got DDOSed and over 10,000 accounts were made all with the same name just a different number at the end.

Is there any way to search for all these users with the part of the name thats the same and then just delete them all? If not can somebody make me a modification?

Please and thank you!

[Adrian.]

Just try running this query, if the Usernames are all the same.

$sql = "DELETE FROM user WHERE `username` = 'theusernamestodelete'";
$result = mysql_query($sql);
echo "Users deleted!";

Adrian