JSON_EXTRACT查询mysql中的{}和 [{},{}中的值]

json_extract(a.tag, '$[*].tag_name.cn') as tag, json_extract(a.address,'$.en') as address_name,
json_extract(a.intro,'$.cn') as intro,

原文地址:https://www.cnblogs.com/fengff/p/9812511.html