$notILike

Filter records where a column’s value does not match a specified pattern, case-insensitively. The $notILike method is used to exclude entries whose values match the given pattern, ignoring case sensitivity. This is useful when you want to exclude certain text values while performing a case-insensitive search.

await Member.$search({
    $where: {
        username: {
            $notILike: '%john%'
        }
    }
});

Last updated