update tbl_test set test_json = JSON_REPLACE( test_json, '$."jsonFieldName"', ( CAST(test_json -> '$."jsonFieldName"' AS SIGNED INTEGER) - 70 * 365 -19 ) * 86400 - 3600 * 8 )
where
test_json -> '$."jsonFieldName"' = "55555" limit 1
版本: mysql8.0
标签:jsonFieldName,字段,更新,json,mysql,test From: https://www.cnblogs.com/supermarx/p/17359339.html