sql查询

--某个字段以逗号分开，往里面追加修改
update tbl_sqt_subwayinfo set subwayname = CONCAT(subwayname,',','6') where id = 4

--某字段以逗号分开，定向删除里面某一个字符，例如下面是删除subwayname中',5'  原来为'1,3,5,6' 执行删除后字段为'1,3,6,'
update tbl_sqt_subwayinfo set subwayname = (REPLACE(subwayname, ',5', '')) where id = 4