$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