String operators

matches regex operator

Learn how to use the matches regex string operator to filter a record set based on a case-sensitive regex value.

String operators

Learn about query operators for searching string data types.

The case-insensitive !~ (not equals) string operator

Learn how to use the !~ (not equals) string operator to filter records for data that doesn’t match a case-insensitive string.

The case-insensitive !contains string operator

Learn how to use the !contains string operator to filter data that doesn’t include a case sensitive string.

The case-insensitive !endswith string operator

Learn how to use the !endswith string operator to filter records for data that excludes a case-insensitive ending string.

The case-insensitive !has string operators

Learn how to use the !has string operator to filter records for data that doesn’t have a matching case-insensitive string.

The case-insensitive !hasprefix string operator

Learn how to use the !hasprefix operator to filter records for data that doesn’t include a case-insensitive prefix.

The case-insensitive !hassuffix string operator

Learn how to use the !hassuffix string operator to filter records for data that doesn’t have a case-insensitive suffix.

The case-insensitive !in~ string operator

Learn how to use the !in~ string operator to filter records for data without a case-insensitive string.

The case-insensitive !startswith string operators

Learn how to use the !startswith string operator to filter records for data that doesn’t start with a case-insensitive search string.

The case-insensitive =~ (equals) string operator

Learn how to use the =~ (equals) operator to filter a record set for data with a case-insensitive string.

The case-insensitive contains string operator

Learn how to use the contains operator to filter a record set for data containing a case-insensitive string.

The case-insensitive endswith string operator

Learn how to use the endswith operator to filter a record set for data with a case-insensitive string.

The case-insensitive has string operator

Learn how to use the has operator to filter data with a case-insensitive string.

The case-insensitive has_all string operator

Learn how to use the has_all string operator to filter a record set for data with one or more case-insensitive search strings.

The case-insensitive has_any string operator

Learn how to use the has_any operator to filter data with any set of case-insensitive strings.

The case-insensitive hasprefix string operator

Learn how to use the hasprefix operator to filter data with a case-insensitive string.

The case-insensitive hassuffix string operator

Learn how to use the hassuffix operator to filter data with a case-insensitive suffix string.

The case-insensitive in~ string operator

Learn how to use the in~ operator to filter data with a case-insensitive string.

The case-insensitive startswith string operator

Learn how to use the case-insensitive startswith string operator to filter a record set with a case-insensitive string starting sequence.

The case-sensitive != (not equals) string operator

Learn how to use the != (not equals) string operator to filter records for data that doesn’t match a case-sensitive string.

The case-sensitive !contains_cs string operator

Learn how to use the !contains_cs string operator to filter data that doesn’t include a case-sensitive string.

The case-sensitive !endswith_cs string operator

Learn how to use the !endswith_cs string operator to filter data that doesn’t contain a case-insensitive string.

The case-sensitive !has_cs string operator

Learn how to use the !has_cs string operator to filter records for data that doesn’t have a matching case-sensitive string.

The case-sensitive !hasprefix_cs string operator

Learn how to use the !hasprefix_cs string operator to filter records for data that doesn’t have a case-sensitive prefix.

The case-sensitive !hassuffix_cs string operator

Learn how to use the !hassuffix_cs string operator to filter records for data that doesn’t have a case-sensitive suffix.

The case-sensitive !in string operator

Learn how to use the !in string operator to filter records for data without a case-sensitive string.

The case-sensitive !startswith_cs string operator

Learn how to use the !startswith_cs string operator to filter records for data that doesn’t start with a case-sensitive search string.

The case-sensitive == (equals) string operator

Learn how to use the == (equals) operator to filter a record set for data matching a case-sensitive string.

The case-sensitive contains_cs string operator

Learn how to use the contains_cs operator to filter a record set for data containing a case-sensitive string.

The case-sensitive endswith_cs string operator

Learn how to use the endswith_cs operator to filter a record set for data with a case-sensitive ending string.

The case-sensitive has_cs string operator

Learn how to use the has_cs operator to filter data with a case-sensitive search string.

The case-sensitive hasprefix_cs string operator

Learn how to use the hasprefix_cs operator to filter data with a case-sensitive prefix string.

The case-sensitive hassuffix_cs string operator

Learn how to use the hassuffix_cs operator to filter data with a case-sensitive suffix string.

The case-sensitive in string operator

Learn how to use the in operator to filter data with a case-sensitive string.

The case-sensitive startswith string operator

Learn how to use the startswith string operator to filter a record set with a case-sensitive string starting sequence.