SQL更新字段内容部分值

UPDATE att_all
SET attachment = REPLACE(attachment, 'pw/', '')
WHERE (attachment LIKE 'pw/%')