replace

UPDATE `tenant_task_config` SET `params` = replace(`params`,'"periods_end": "10"','"periods_end": "15"') WHERE `key_id` in (3523,3560); ///替换 tenant_task_config 表中,params 字段 里面的    "periods_end": "10"   为  "periods_end": "15"

原文地址:https://www.cnblogs.com/xiaoniuniu886/p/14776698.html