How do I delete a batch of customers based on certain criteria?

[kelvyn]

I see that in the email centre, there's an option to email customers who have never purchased, and one for all subscribers, but although I've had a look round the functions, I think I'm a bit too dim to do the following, even in mysql!
I simply want to delete all customers who registered over 6 months ago AND have never bought anything AND who are not newsletter subscribers.

Any ideas appreciated! Thanks

[kelvyn]

I don't like "bumping" threads, but one last attempt - if anyone knows the answer to this, it would be great! Thanks

[afo]

You should be able to do this from your webmaster panel using phpMyAdmin, but I'll have to give some thought to what the mySQL statement would have to be. If you can give me a little time, I'll see what I can do, but I recommend using phpMyAdmin to backup your database before trying something like this.