基础数据:
拼接: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
结果:
