replace(obj, search, replace_str)函数
update 表 set 字段 = replace(字段, 指定字符串, 目标字符串)
update people set people_role = replace(people_role, 'test', '')
replace(obj, search, replace_str)函数
update 表 set 字段 = replace(字段, 指定字符串, 目标字符串)
update people set people_role = replace(people_role, 'test', '')