摘要:
update Friendship set friendGroup = trim(leading "2," from friendGroup) where friendGroup REGEXP "^2,([:digit:],)*" ;

update Friendship set friendGroup = replace (friendGroup,',2,',',') where friendGroup REGEXP ",2,([:digit:],)*" ;
  阅读全文