Forum Need help with SQL if possible
 

vBulletin 4.2.0 Patch Level 2
--------------------------------

I have a moderator who has been identifying spammers and bots by putting "--spammer--" in the signature field.

I have a "To Be Pruned" usergroup (id 36) and I want a SQL to move all users with "--spammer--" in the signature field to usergroup 36.

I am a SQL beginner and I can't seem to get the join right. :(

If anyone could help, I would really appreciate it.

Thanks!


John