模糊匹配jsonObject字段
select * from tableName where columnName -> '$.xx' like '%xx%'
精确匹配jsonObject类型字段
select * from tableName where columnName -> '$.xx' = 'xx'
模糊匹配jsonArray字段
select * from tableName where columnName -> '$[*].xx' like '%xx%'
精确匹配jsonArray字段
select * from tableName where JSON_CONTAINS(columnName, JSON_OBJECT('xx','xx'))
jsonArray 取值
select JSON_UNQUOTE(json_extract(columnName,'$[0]')) from tableName
标签:tableName,Json,columnName,xx,MySql,字段,where,select
From: https://www.cnblogs.com/Linzj5950/p/17778550.html