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,

posted on 2018-10-18 19:05  枫飞飞  阅读(3462)  评论(0编辑  收藏  举报