目前有一组数据格式为: 123,223,323,423 我想通过查询223为条件把数据变成123,222,323,423这个sql语句应该如何实现谢谢。
update 表名 set 列名=replace(列名,'223','222');
update table set field = replace(field,',223,',',222,')
update table set A=replace(A,'223','222')
update table set field = replace(field,"223","222") where FIND_IN_SET("223",field);
update table set secondcolume="222" where secondcolume="223";
update [表名] set [列名]=replace(列名,'223','222');
update table set fieldA='xxxx' where fieldB like '%,223,%'
update table set a=a-1 where a=223
update 表名
set列名='123,222,323,423'
where 233='123,223.323,423'