mysql的replace函数
将单引号与双引号的替换,有时候在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
###################################
igoodful@qq.com
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步