在MySQL中没有内置的函数来查找多个JSON结构的交集。文中提供了一个自定义的MySQL函数MY_JSON_INTERSECT，用于找出两个JSON数组的交集。函数通过遍历较短的数组并检查元素是否存在于较长的数组中来实现。虽然效率不高，但可以解决这个问题。
The question is about MySQL/MariaDB JSON Functions.
How do you find intersection of multiple JSON structures?
In PHP it is done using this code:
array_intersect(
['a', 'b'],
['b', 'c']
);
If we imagine a function named JSON_INTERSECT, the code would look like this:
SET @json1 = '{"key1": "a", "key2": "b"}';
SET @json2 = '["b", "c"]';
SET @json3 = '["c", "d"]';
SELECT JSON_INTERSECT(@json1, @json2); // returns '["b"]';
SELECT JSON_INTERSECT(@json1, @json3); // returns NULL;
解决方案
It looks there are no good built-in ways of doing this and there are still no good answers on this topic, so I thought I'd add my
最低0.47元/天 解锁文章
645
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
