How do I remove ALL signtures from the registered usergroup. (#2)
I found one query which got rid of all signatures that had URL's in it, it worked but I want to get rid of all signatures for that usergroup.
UPDATE usertextfield AS ut INNER JOIN user AS u ON ut.userid = u.userid SET signature=NULL WHERE ut.signature LIKE '%url%' AND u.usergroupid = 2;
I found one query which got rid of all signatures that had URL's in it, it worked but I want to get rid of all signatures for that usergroup.
UPDATE usertextfield AS ut INNER JOIN user AS u ON ut.userid = u.userid SET signature=NULL WHERE ut.signature LIKE '%url%' AND u.usergroupid = 2;
Comment