慕缘小栈

一切从简

批量替换MYSQL字段内容

update blog set abc=replace(abc,’bcd’,’cde’); 

blog 是表名 abc 是字段名 bcd 是被替换字段  cde 是替换字段

0
0
Tags:
Previous Article
Next Article

发表回复

Your email address will not be published. Required fields are marked *.

*
*