就是删除(或替换)里面值为空id----name 1-----,1,11,112,13,19,23,1234,34比如替换那么中1后结果为,11,112,13,19,23,1234,34 比如替换那么中11后结果为,1,112,13,19,23,1234,34 比如替换那么中112后结果为,1,11,13,19,23,1234,34试试看吧: update 表a set name = replace(name,",1","");
应是update 表a set name = replace(name, ',1', ''); 刚才用了双引号,不过也可以运行。
replace() 函数可以满足你的需求
update t set name = TRIM(TRAILING ',' FROM REPLACE(CONCAT(name,','),',1,',',')) where name = 值;
根据你的需求,分别是三个语句。 id----name 1-----,1,11,112,13,19,23,1234,34比如替换那么中1后结果为,11,112,13,19,23,1234,34 update 表a set name = replace(name, ',1,', ',');比如替换那么中11后结果为,1,112,13,19,23,1234,34 update 表a set name = replace(name, ',11,', ',');比如替换那么中112后结果为,1,11,13,19,23,1234,34 update 表a set name = replace(name, ',112,', ',');
1-----,1,11,112,13,19,23,1234,34比如替换那么中1后结果为,11,112,13,19,23,1234,34
比如替换那么中11后结果为,1,112,13,19,23,1234,34
比如替换那么中112后结果为,1,11,13,19,23,1234,34
1-----,1,11,112,13,19,23,1234,34比如替换那么中1后结果为,11,112,13,19,23,1234,34
比如替换那么中11后结果为,1,112,13,19,23,1234,34
比如替换那么中112后结果为,1,11,13,19,23,1234,34试试看吧:
update 表a set name = replace(name,",1","");
刚才用了双引号,不过也可以运行。
id----name
1-----,1,11,112,13,19,23,1234,34比如替换那么中1后结果为,11,112,13,19,23,1234,34
update 表a set name = replace(name, ',1,', ',');比如替换那么中11后结果为,1,112,13,19,23,1234,34
update 表a set name = replace(name, ',11,', ',');比如替换那么中112后结果为,1,11,13,19,23,1234,34
update 表a set name = replace(name, ',112,', ',');