<span>mysql的replace函数</span>
将单引号与双引号的替换，有时候在json处理中需要：
dba@xxx ((none)) > select replace('xxxx"12345"677777','\"',"'"); +---------------------------------------+ | replace('xxxx"12345"677777','\"',"'") | +---------------------------------------+ | xxxx'12345'677777 | +---------------------------------------+ 1 row in set (0.07 sec) Thu Nov 12 17:14:03 2020 dba@xxx ((none)) > select replace("xxxx'12345'677777","'",'\"'); +---------------------------------------+ | replace("xxxx'12345'677777","'",'\"') | +---------------------------------------+ | xxxx"12345"677777 | +---------------------------------------+ 1 row in set (0.07 sec) Thu Nov 12 17:15:44 2020
###################################
投递CVTE等公司10个岗位 >
锐捷网络股份有限公司公司福利 349人发布
