Functions That Search JSON Values select_type: SIMPLE table: t2 partitions: NULL type: ref possible_keys: i1 key: i1 key_len: 5 ref: const rows: 1 filtered: 100.00 Extra: NULL For information about using indexes on generated columns for indirect indexing of  JSON  columns, see Indexing a Generated Column to Provide a JSON Column Index. Returns true (1) if  value  is an element of  json_array , otherwise returns false (0).  value  must be a scalar or a JSON document; if it is a scalar, the operator attempts to treat it as an element of a JSON array. Queries using  MEMBER OF()  on JSON columns of  InnoDB  tables in the  WHERE  clause can be optimized using multi-valued indexes. See Multi-Valued Indexes, for detailed information and examples. Simple scalars are treated as array values, as shown here: • value  MEMBER OF( json_array ) mysql>  SELECT 17 MEMBER OF(’[23, "abc", 17, "ab", 10]’); +-------------------------------------------+ | 17 MEMBER OF(’[23, "abc", 17, "ab", 10]’) | +-------------------------------------------+ | 1 | +-------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT ’ab’ MEMBER OF(’[23, "abc", 17, "ab", 10]’); +---------------------------------------------+ | ’ab’ MEMBER OF(’[23, "abc", 17, "ab", 10]’) | +---------------------------------------------+ | 1 | +---------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT 7 MEMBER OF(’[23, "abc", 17, "ab", 10]’); +------------------------------------------+ | 7 MEMBER OF(’[23, "abc", 17, "ab", 10]’) | +------------------------------------------+ | 0 | +------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT ’a’ MEMBER OF(’[23, "abc", 17, "ab", 10]’); +--------------------------------------------+ | ’a’ MEMBER OF(’[23, "abc", 17, "ab", 10]’) | +--------------------------------------------+ | 0 | +--------------------------------------------+ 1 row in set (0.00 sec) mysql>  SELECT ->  17 MEMBER OF(’[23, "abc", "17", "ab", 10]’), Partial matches of array element values do not match: Conversions to and from string types are not performed: 2362