参考链接:
Mysql5.7 + 查询并解析json数据方法_mysql解析json字符串_Stuild Stuil的博客-CSDN博客
mysql 去除双引号_mysql去掉json的双引号_Iloveskr的博客-CSDN博客
我的例子:
json数据:
{"age":"55岁","asst_exam_rslt":"详见报告单。","brdy":"1967-07-20T00:00:00","caty":"01000307","chfcomp":"反复上腹部疼痛1周复诊","dept":"中医门诊","dise_now":"1周前无明显诱因下出现反复上腹部剑突下疼痛,阵发性,无恶心呕吐,无畏寒发热,无胸闷心悸,曾在外院行电子胃镜检查示十二指肠球部溃疡A1期,今转我院门诊继续维持治疗,既往有高血压、痛风病史,规律外院诊治。否认发病前21天内有新冠肺炎国内中高风险地区,或其他有病例报告社区,境外的旅行史或居住史。否认发病前21天内与新型冠状病毒感染者(核酸检测阳性者)有接触史。否认发病前21天内曾接触过来自国内中高风险地区,或来自有病例报告社区的发热或有呼吸道症状者。否认聚集性发病。","drord":{"tcmherb":[{"drord_no":"1","id":"EF864FF6F2975EDCE0531608A8C04BDE1","lssu_dept":"01000307","lssu_time":"2022-12-11 12:18:55","lssuer":"1344","memo":"136","tcmherb_items":[{"decocting_method":"","drug_code":"258091","drug_name":"(代