mysql REPLACE()函数替换包含反斜杆字段的问题

— 查询包含反斜杠的字符串 https:\/\/mp.weixin.qq.com\/s\/7SA4E5UYChkxU0gk69HgWg

UPDATE table
SET content = REPLACE (
content,
‘https:\/\/mp.weixin.qq.com\/s\/7SA4E5UYChkxU0gk69HgWg’, — 原包含反斜杠的字符串 此处增加一个反斜杠
‘https:\/\/www.baidu.com\/aaaa\/bbb?id=cccc’ — 新包含反斜杠的字符串 此处增加一个反斜杠
)
WHERE
content LIKE “%https:\\/\\/mp.weixin.qq.com\\/s\\/7SA4E5UYChkxU0gk69HgWg%”;– 此处增加3个反斜杠