replace函数问题

Question

replace('','','')
问题是参数中包含引号 ‘
select replace('五爱北路金置电脑广场','新交电胜利门','胜利门','吉祥桥江苏银行','火车站'','','','-')
怎么弄 3Q

Answer 1

select * from tb/**
col                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
------------------------------------------------------------------------------------------
'梅园公交总站','梅园','开原寺','大渲','公益路','荣巷607所',
'张巷','王巷滨湖医院','上里东','河埒口','四院','青山湾','锡惠公园','五爱广场中信银行',
'五爱北路金置电脑广场','新交电胜利门','胜利门','吉祥桥江苏银行','火车站' （所影响的行数为 1 行）
**/update tb
set col=replace(replace(col,'''',''),',','-')
goselect * from tb
/**
col                                                                       
------------------------------------------------------------------------
梅园公交总站-梅园-开原寺-大渲-公益路-荣巷607所-
张巷-王巷滨湖医院-上里东-河埒口-四院-青山湾-锡惠公园-五爱广场中信银行-
五爱北路金置电脑广场-新交电胜利门-胜利门-吉祥桥江苏银行-火车站 （所影响的行数为 1 行）
**/