sql 正则表达式替换json值

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

    },

    }

}

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

SET @j = '{
    "workResult":{
        "ways":[],

        "noRoad":0,

        "roadIds":[],

        "workTime":13705,

        "direction":[],

        "task_status":0,

        "reflow_editor":"zw799269",

        "reflow_team_id":11,

        "reflow_work_time":1606354665493

    },

    "transferResult":{},

    "resultHandleResult":{
 

    }

}';
SELECT JSON_REMOVE(@j, '$.transferResult', '$.resultHandleResult');

mysql5.7 https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html#function_json-remove

为什么不用 substr( ) + instr( ) 来解决这个问题？这种问题不适合用正则