– UPDATE user set shop_ids = json_set(shop_ids,’
[
0
]
′
,
221
)
W
H
E
R
E
J
S
O
N
O
V
E
R
L
A
P
S
(
s
h
o
p
i
d
s
−
>
′
[0]',221) WHERE JSON_OVERLAPS(shop_ids->'
[0]′,221)WHEREJSONOVERLAPS(shopids−>′[]’,’[231]’)
– SELECT * FROM user WHERE JSON_OVERLAPS(shop_ids->’
[
∗
]
′
,
′
[
231
]
′
)
−
−
S
E
L
E
C
T
∗
,
j
s
o
n
s
e
t
(
s
h
o
p
i
d
s
,
′
[*]','[231]') -- SELECT *,json_set(shop_ids,'
[∗]′,′[231]′)−−SELECT∗,jsonset(shopids,′[0]’,231) FROM user WHERE JSON_OVERLAPS(shop_ids->’$[]’,’[231]’)
mysql JSON数组字段增加唯一值
最新推荐文章于 2022-06-20 10:39:08 发布