UPDATE mybb_users SET signature = 'New sig here... Remember to escape any characters' WHERE usergroup IN(3,4,6)