590
社区成员
发帖
与我相关
我的任务
分享
set @d:='1,2,3,12,13,1,14';
select replace(trim(replace(replace(concat(' ',@d,' '),',',' '),' 1 ',' ')),' ',',') as dd;
/*
dd
2,3,12,13,14
*/
update `user` set devid = trim(both ',' from replace(concat(',', devid, ','), ',1,', ','))
update `user` set devid = replace(devid,'1,','')
create table test(id int, name varchar(30));
insert into test values(1,'1,2,12,13,23,55');
insert into test values(2,'22,33,56,61');
insert into test values(3,'1');
insert into test values(4,'');
update test
set name = trim(both ',' from replace(concat(',', name, ','), ',1,', ','));
select * from test;
drop table test;