説明
検索対象の要素がJSON配列のいずれかの要素と一致する場合、この関数は1を返します。そうでない場合は0を返します。
構文
value MEMBER OF(json_array)
説明
value が json_array の要素である場合は1を返し、そうでない場合は0を返します。
value はスカラーまたはJSONドキュメントでなければなりません。スカラーの場合、演算子はそれをJSON配列の要素として扱います。
例
obclient> SELECT 45 MEMBER OF('[123, "abc", 45, "ab", 10]');
+--------------------------------------------+
| 45 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+--------------------------------------------+
| 1 |
+--------------------------------------------+
1 row in set
obclient> SELECT 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]');
+---------------------------------------------+
| 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]') |
+---------------------------------------------+
| 1 |
+---------------------------------------------+
1 row in set
obclient> SELECT 5 MEMBER OF('[123, "abc", 45, "ab", 10]');
+-------------------------------------------+
| 5 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
1 row in set
obclient> SELECT
45 MEMBER OF('[23, "abc", "45", "ab", 10]'),
"45" MEMBER OF('[23, "abc", 45, "ab", 10]')\G
*************************** 1. row ***************************
45 MEMBER OF('[23, "abc", "45", "ab", 10]'): 0
"45" MEMBER OF('[23, "abc", 45, "ab", 10]'): 0
1 row in set
obclient> SELECT CAST('[4,5]' AS JSON) MEMBER OF('[[3,2],[4,5]]');
+--------------------------------------------------+
| CAST('[4,5]' AS JSON) MEMBER OF('[[3,2],[4,5]]') |
+--------------------------------------------------+
| 1 |
+--------------------------------------------------+
1 row in set
obclient> SELECT JSON_ARRAY(4,5) MEMBER OF('[[3,2],[4,5]]');
+--------------------------------------------+
| JSON_ARRAY(4,5) MEMBER OF('[[3,2],[4,5]]') |
+--------------------------------------------+
| 1 |
+--------------------------------------------+
1 row in set