数据库语句更新某个字段的某个内容

UPDATE upload SET save_directory=REPLACE (save_directory,'f:','d:') WHERE save_directory LIKE "%f:%"

update content_attach set savePath=replace(savePath,'f:','d:') where savePath like "%f:%"

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/oymx/p/4182296.html