prune spamers
 

I have like 850 spam bots accounts to ban or delete
It's easy to spot them because I have some custom profile field and they always select the first option in first field

Now while vb can show them to be it won't let me mass move them to banned usergroup, the move/prune filters are kind of anemic

I intend to mass move them to banned user group with sql query since there seems to be no other way
here are the sql tables which matter

vb_user // userid // usergroupid
vb_userfield // userid // field2

I'm not a sql expert so please tell me the query ONLY IF YOU'RE 100% SURE Thank you

I want also to delete the homepage field of all these spamers as these sneaky bastards use it to promote malicious websites