了解知识
MySQL Replace 替换函数语法:
update TABLE_NAME set 字段名 = replace(字段名, "原来的值", "要替换成的值");
 
MySQL Replace 举例:
update user set name = replace(name, "zhangsan", "lisi")
 
OK, 如此MySQL就将所有名字为zhangsan的字符串替换成lisi啦~
标签: MySQL
扩展知识