UPDATE 数据表名 SET 字段名 = replace(字段名, '要替换的字符串', '替换为') WHERE 设定条件;
UPDATE attendance SET remark = replace(remark, '工作', '2014国庆节') WHERE id >= 308097 and id<308195;
UPDATE 数据表名 SET 字段名 = replace(字段名, '要替换的字符串', '替换为') WHERE 设定条件;
UPDATE attendance SET remark = replace(remark, '工作', '2014国庆节') WHERE id >= 308097 and id<308195;