[tpearl5]

Originally Posted by scottct1

How do I just remove ALL signatures from the Registered usergroup?

UPDATE usertextfield AS ut
INNER JOIN user AS u ON ut.userid = u.userid SET signature=NULL
WHERE u.usergroupid = 2;

I haven't tested this, I would run it as a SELECT statement first to make sure that you are getting the right data, like this:

SELECT * FROM usertextfield AS ut
INNER JOIN user AS u ON ut.userid = u.userid
WHERE u.usergroupid = 2;

Do a backup! Once it's gone it's gone!