求一条SQL语句

[beckham1122]

select replace(字段a,"abc","") as aa from 表a
只能实现替换一个字符，如果有多个字符需要同时替换怎么写？谢谢

[子陌红尘]

replace( replace( replace('...','...','...'),'...','...'),'...','...')  ??

[htl258_Tony]

可以同时啊
select replace('abcdefgabc','abc','') a
a                                                                                                                                                                                                                                                              
----
defg

（所影响的行数为 1 行）

[百年树人]

select 
  replace(replace(replace(字段a,'a',''),'b',''),'c','') as aa 
from 表a 

[htl258_Tony]

要多个就像一楼那样,套多层.

[sxqqtj]

replace(replace(字段a,'abc',''),'edf','')

[肥龙上天]

[Quote=引用 3 楼 josy 的回复:]
SQL codeselect
replace(replace(replace(字段a,'a',''),'b',''),'c','') as aa
from 表a
[/Quote]
顶一个

[Roc_Lee]

[Quote=引用 3 楼 josy 的回复:]
SQL codeselect
replace(replace(replace(字段a,'a',''),'b',''),'c','') as aa
from 表a
[/Quote]
这个可行啊，楼主

[sdhdy]

用多层replace()啊。

[Terry717]

多个字符需要同时替换就用多个replace

[dawugui]

[Quote=引用楼主 raul1122 的帖子:]
select replace(字段a,"abc","") as aa from 表a
只能实现替换一个字符，如果有多个字符需要同时替换怎么写？谢谢
[/Quote]
select replace(replace(字段a,'abc',''),'def','') as aa from 表a

[bluefangxiao]

多用几个replace就可以了

[ljhcy99]

sql2008:
select replace('abcdefgabcabcdabca','abc','') a


结果：defgda