$overlap

Filter records where a column’s value has any overlap with the specified set of values. The $overlap method is used for comparing arrays or sets, retrieving entries where the value in the column shares common elements with the provided set. This is particularly useful when working with array or JSON-type columns.

await Member.$search({
    $where: {
        badges: {
            $overlap: ['VIP','CEO']
        }
    }
});