◀ Back to Playground Home

Find the index of integer value in multi value column

select arrayIndexOfInt(int_mv_field, 100)  AS value, int_mv_field
from users 
WHERE value != -1
limit 10