Regex

Regex is used with Where to search for a specified pattern in a column value. For more information about regex, visit mozilla regular expression guide

var results = await connection.select({
    from: 'Customers',
    where: {
        Country: {
            regex: /mexico|brazil/i
        }
    }
});
//results will be array of objects.
console.log(results);

Example