[tpearl5]

And a slightly more complex query if you want to remove signatures from a specific user group:

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;

Replace 2 with the user group you want to remove signatures for.