MEMBER OF

Description

This function returns 1 if the specified value is an element of the specified JSON array, and 0 otherwise.

Syntax

value MEMBER OF(json_array)

Description

If value is an element of json_array, the function returns 1. Otherwise, it returns 0.

value must be a scalar or a JSON document. If it is a scalar, the operator treats it as an element of the JSON array.

Examples

SELECT 45 MEMBER OF('[123, "abc", 45, "ab", 10]');
+--------------------------------------------+
| 45 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+--------------------------------------------+
|                                          1 |
+--------------------------------------------+
1 row in set (0.001 sec)

SELECT 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]');
+---------------------------------------------+
| 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]') |
+---------------------------------------------+
|                                           1 |
+---------------------------------------------+
1 row in set (0.001 sec)

SELECT 5 MEMBER OF('[123, "abc", 45, "ab", 10]');
+-------------------------------------------+
| 5 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+-------------------------------------------+
|                                         0 |
+-------------------------------------------+
1 row in set (0.001 sec)

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 (0.001 sec)

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 (0.001 sec)

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 (0.001 sec)