Mysql Replace函数

--replace方法
UPDATE fsys_model_info SET model_mst_map_path=REPLACE(model_mst_map_path, 'abc', 'def');
--group by连接操作符 group_concat
select field1,group_concat(field2) as all from table group by field1
--找字段重复的记录
select field1 from table group by field1 having count(field1) > 1