给位大哥哥大姐姐都过来救救小弟吧,下面是我数据库中的一些数据。
accout email ID
jinjie302 [email protected] 16149
chendu [email protected] 16163
bufu123 [email protected] 16181
sw520wy [email protected] 16224
sunfeifei [email protected] 16225怎样才能把前面的“WWW.”去掉
ps(这些人憨呆了!!!)
accout email ID
jinjie302 [email protected] 16149
chendu [email protected] 16163
bufu123 [email protected] 16181
sw520wy [email protected] 16224
sunfeifei [email protected] 16225怎样才能把前面的“WWW.”去掉
ps(这些人憨呆了!!!)
SET EMAIL=STUFF(EMAIL,1,4,'')
WHERE EMAIL LIKE 'WWW.%'
set email=case when left(email,4)='www.' then right(email,len(email)-4) else email end
UPDATE TB SET EMAIL=REPLACE(EMAIL,'WWW.','')
set email=case when left(email,4)='www.' then right(email,len(email)-4) else email end
SET EMAIL=STUFF(EMAIL,1,4,'')
WHERE EMAIL LIKE 'WWW.%'
这个语句会出问题