$iLike

Filter records where a column’s value matches a specified pattern, case-insensitively. The $iLike method is used for case-insensitive string matching, making it useful for flexible searches where the case of the text should not affect the results.

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