mysql取json值

2021-03-02 本文已影响0人杜子龙

SELECT json_extract(msg_body,'$.head.randNum'),a.msg_body FROM `message_record` a limit 1;