Delete users in bulk

[Powlo]

Ive just done a user search using mail.ru as the search field and i have some 89-90 members with that address, obviously they are all bot generated so i want to delete them all but i'm wondering if there is a way of deleteing them all in one go rather than one at a time.

[bananalive]

Be careful running sql queries but you would want something like this:

[sql]DELETE FROM vb_user WHERE email='%@mail.ru'[/sql]

(you might need to change table prefix)

[Lynne]

Just my two cents, but I have several valid users using that mail extension.

[Dismounted]

Originally Posted by bananalive

Be careful running sql queries but you would want something like this:

[sql]DELETE FROM vb_user WHERE email='%@mail.ru'[/sql]

(you might need to change table prefix)

There is more to a removing user than just removing that row. You should use a SELECT query to find all the IDs, then use the User Data Manager to delete the user.

[jesusdlg]

Hi Dismounted,

Will you share the proper query in order to do this?

I also want to delete all users with mail.ru from my vbulletin forum.

Thanks