mysql 拼接字符串,和删除某个字段找中的 某个字符串

 基础数据:

  

拼接:concat()

 ##拼接字符串
update z_test set test = CONCAT("前面添加字符串",test,"中间添加字符串",test,"后面添加字符串") where id = 1;

结果:

  删除或者替换:replace()

##过滤(删除)字符串
update z_test set test = REPLACE(test,"BB","") where id = 2

结果:

##替换字符串
update z_test set test = REPLACE(test,"CC","66666") where id = 3

结果: