mysql 常用sql记录

1、替换表中某字段的某部分字符串

　　update tasktemplate set taskreferphotourl = replace(taskreferphotourl,"/marketmix","/marketdata")