单个json对象的操作写法:
SELECT
*
FROM
`log_info` li
WHERE
( old_data_info, '$.law_person_name' ) = '三公子'
如果json存的数组的写法:
SELECT
*
FROM
`log_info` li
WHERE
old_data_info->'$[*].lawPersonName' like '%三公子%'
分组查询菲关系型数据
SELECT
student_id,
GROUP_CONCAT(
JSON_OBJECT( 'student_id', student_id, 'kmmc', kmmc, 'score', score ))
FROM
cj
GROUP BY
student_id