array_position

    Syntax

    返回value在数组中第一次出现的位置/索引。

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

    ARRAY,POSITION,ARRAY_POSITION