--某个字段以逗号分开,往里面追加修改
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
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