MySQL 字段前缀、后缀、替换操作

添加前、后缀 concat，字符串替换 replace

#添加前缀
UPDATE `table` SET field_name = concat("前缀", field_name);

#添加后缀
UPDATE `table` SET field_name = concat(field_name, "后缀");

#批量替换
UPDATE `table` SET field_name = REPLACE(intro, "before_replace", "after_replace");