update phome_ecms_表 set 替换字段=REPLACE(替换字段,'原字符','新字符')
UPDATE phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'原来','现在')
相关阅读:
sql语句:按照id顺序把帝国已发文章的tags字段值全部替换成关键字的字段值
https://www.iduyao.cn/topics/229
update phome_ecms_表 set 替换字段=REPLACE(替换字段,'原字符','新字符')
UPDATE phome_ecms_news_data_1 SET newstext=REPLACE(newstext,'原来','现在')