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 __DEFINE_LIKE_SHARE__