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:],)*" ;
posted on 2008-09-16 21:33
小咔咔 阅读(402)
评论(2) 编辑 收藏 所属分类:
SQL