Need to purge all signatures - help with query

[stwilson]

I just updated my site to VB and need to purge all the existing signatures from every user account in a specific user group. Any suggestions on the query I should use?

[Marco van Herwaarden]

Not tested but something like the following:
[sql]UPDATE usertextfield AS utf, user AS u
SET utf.signature = NULL
WHERE utf.userid=u.userid
AND u.usergroupid = 6;[/sql]
Replace 6 by the usergroup.

Test first on a testboard and make a backup before running manual SQL commands on your production database.

[stwilson]

Marco,

Thank you. That worked like a charm.