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

# 删除
update z_test set test = REPLACE(test,"BB","") where id = 2  

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