$contained

Filter records where a column’s value is fully contained within the specified set or value. The $contained method is used to check if the column’s value is a subset of the provided set or array, ensuring that all elements of the column’s value are present in the specified range. This is useful for checking relationships between arrays or sets.

await Member.$search({
    $where: {
        badges: {
            $contained: 'VIP'
        }
    }
});