MySQL查询字段类型为json的数据

"""select * from table where json_contains(param-> '$[*]','{}'.format(id))
"""

select json_extract(param,'$.name'), count(json_extract(param,'$.name')) from table
where json_extract(param,'$.name') is not null 
group by json_extract(param,'$.name')

eg1
eg2
eg3
eg4