INSERT INTO `test` ( `id`, `test_json)VALUES( '1', '{"deptId":"c6d7cb4deeac411cb3384b1b3 a1278596", "workNo":"00001", "post":"test"}' );
查询:
WHERE test_json-> '$.companyId' = '1300265503642865665';
test_json->> '$.workNo' workNo,
INSERT INTO `test` ( `id`, `test_json)VALUES( '1', '{"deptId":"c6d7cb4deeac411cb3384b1b3 a1278596", "workNo":"00001", "post":"test"}' );
查询:
WHERE test_json-> '$.companyId' = '1300265503642865665';
test_json->> '$.workNo' workNo,