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
小咔咔 閱讀(421)
評(píng)論(2) 編輯 收藏 所屬分類:
SQL