sql 正则表达式替换json值

Question

sql 如何使用正则表达式，输出结果不包括transferResult，resultHandleResult，最终实现的效果如下

案例：

{

    "workResult":{

        "ways":Array[1],

        "noRoad":0,

        "roadIds":Array[1],

        "workTime":13705,

        "direction":Array[2],

        "task_status":0,

        "reflow_editor":"zw799269",

        "reflow_team_id":11,

        "reflow_work_time":1606354665493

    },

    "transferResult":Object{...},

    "resultHandleResult":{

 

    }

}

 

效果：

{

    "workResult":{

        "ways":Array[1],

        "noRoad":0,

        "roadIds":Array[1],

        "workTime":13705,

        "direction":Array[2],

        "task_status":0,

        "reflow_editor":"zw799269",

        "reflow_team_id":11,

        "reflow_work_time":1606354665493

    },

 

    }

}

Answer 1

这是数据结构转换吧，跟sql有关系？现在的sql又是什么