| id | info |
| 1 | {"con_id":"105","doctor_id":"134"} |
| 2 | {"con_id":"107","status":"True"} |
select get_json_object(info,'$.con_id') from test
运行结果:
| info |
| 105 |
| 107 |

| id | info |
| 1 | {"con_id":"105","doctor_id":"134"} |
| 2 | {"con_id":"107","status":"True"} |
select get_json_object(info,'$.con_id') from test
运行结果:
| info |
| 105 |
| 107 |