How to mass delete Spam customers

Hi,

I'am very new to this and just wondered if there is any way to quickly select all my spam customer accounts and delete them? ATM it only lets me delete 1 at a time then resets me back to the beginning.

Thanks,

lucas

Using the admin GUI, no.   If you can use SQL (have a tool like SSMS or host SQL console), I can provide some SQL scripts.

yes please!

I suggest you enable captcha setting for security no spam customer can register

Here's a SQL I use.  Many spammers will put very large text in first name field.

DELETE [Customer]
WHERE [Id] IN (select [EntityId] from [GenericAttribute] where [KeyGroup] = 'Customer' and [Key] = 'FirstName' and  len(value) > 50 )

(You may want to first "select * " with just the inner query part to be sure your not deleting any legitimate customers)