Delete users?

[dklassen]

Is there a mod available that allows to mass delete users with a particular name or part of a word in their user name?

[borbole]

Originally Posted by dklassen

Is there a mod available that allows to mass delete users with a particular name or part of a word in their user name?

I haven''t seen such a mod myself. Try to request it at the (paid/unpaid) request forums and hopefully someone will code it for you.

Or you can do it with a query. To delete all users that have a particular name or part of a word in their user name, first make a backup of your users table and then try this query:

DELETE FROM user WHERE username LIKE '%name%';

if you are using a prefix for your db tables, append it to the table name and replace name with the actual word that you want to delete all users who has it in their username.

[dklassen]

Thanks. The query sounds a little scary but I may give it a go.

[borbole]

Originally Posted by dklassen

Thanks. The query sounds a little scary but I may give it a go.

You are welcome. Do not forget to backup your user table first before you run it.

Or you can also try this. Make a duplicate of your live forum to a test folder/subdomain using a new db and then try the query at the test db first to see how thing will go.