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. 

• value  MEMBER OF( json_array ) 

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: 

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) 

Partial matches of array element values do not match: 

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) 

Conversions to and from string types are not performed: 

mysql> SELECT -> 17 MEMBER OF(’[23, "abc", "17", "ab", 10]’), 

