$like

Filter records where a column’s value matches a specified pattern. The $like method is used for partial string matching, typically with wildcards such as % (any sequence of characters) or _ (single character), making it useful for text searches with flexible criteria.

await Member.$search({
    $where: {
        username: {
            $like: '%bes%'
        }
    }
});