selectdb 如何查询json数据是否含有某个数组

Viewed 21

["SD00000003","SD00000002","SD00000017","SD00000021","SD00000028","SD00000020","SD00000071"]

如上数组格式,如果通过sql查询里边是否包含某个数组

1 Answers

看看array_contains函数和json_contains函数是否满足你的需求