sql替换json属性

Question

transferResult 展开后字符太多了，想替换成空值，原json格式不变。请问sql使用说明函数可以

{
    "workResult":{
        "ways":Array[1],
        "noRoad":0,
        "roadIds":Array[1],
        "workTime":13705,
        "direction":Array[2],
        "task_status":0,
        "reflow_editor":"wb-zw799269",
        "sub_task_type":"co_guide_standard",
        "reflow_team_id":11,
        "reflow_work_time":1606354665493
    },
    "transferResult":Object{...},
    "resultHandleResult":{

    }
}

Answer 1

没明白，如果你想置空，转json前置空就行了