mysql8 json字段查询小白demo

snapshot 是json字段 格式二维数组

[

{"new": 1mysql字段, "uid": 350, "add_time": 1582679367, "cart_num": 2, "share_uid": "314", "truePrice": "19.90", "unique_id": 309, "product_id": "2"},

{"new": 1, "uid": 350, "add_time": 1582679367, "cart_num": 2, "share_uid": "314", "truePrice": "19.90", "unique_id": 309, "product_id": "13"},

{"new": 1, "uid": 350, "add_time": 1582679367, "cart_num": 2, "share_uid": "314", "truePrice": "19.90", "unique_id": 309, "product_id": "17"}

]

// product_id 同时包含 [13,17] 的查询

SELECT snapshot->"$[*].product_id" FROM `order_master` WHERE JSON_CONTAINS(snapshot->'$[*].product_id','["13","17"]') LIMIT 0, 10

// product_id 的值有在 ["13","17","89"] 中的一个即满足 类似 IN

SELECT snapshot->"$[*].product_id" FROM `order_master` WHERE JSON_OVERLAPS(snapshot->'$[*].product_id','["13","17","89"]') LIMIT 0, 10

// *注：["13","17","89"]数字是否加引号根据你的product_id 值得类型而定

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!