array_contains

    Syntax

    判断数组中是否包含value。返回结果如下：

    1. mysql> set enable_vectorized_engine=true;
    3. +------+-----------------+------------------------------+
    4. | id   | c_array         | array_contains(`c_array`, 5) |
    6. |    1 | [1, 2, 3, 4, 5] |                            1 |
    7. |    2 | [6, 7, 8]       |                            0 |
    8. |    3 | []              |                            0 |
    9. |    4 | NULL            |                         NULL |
    12. +--------------------------------------+
    13. | array_contains(ARRAY(NULL, 1), NULL) |
    14. +--------------------------------------+
    15. |                                    1 |
    16. +--------------------------------------+

    ARRAY,CONTAIN,CONTAINS,ARRAY_CONTAINS