SQL更新字段内容部分值

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

posted @ 2016-08-08 13:41  Xander_1  阅读(2339)  评论(0)  编辑  收藏  举报