mysql. 替换数据库中某个字段

UPDATE
sys_app_user  u
SET  u.QRCODE_IMAGE_URL=REPLACE(QRCODE_IMAGE_URL,'http://117.78.43.202:8080','http://www.pqsas.com')
WHERE  u.USER_ID='0f04b3a10a464bd5a272d7c07565b288'
原文地址:https://www.cnblogs.com/fireinwater/p/6857077.html