Skip to main content

StringComparisonExp

Boolean expression to compare columns of type "String". All fields are combined with logical 'AND'.

input StringComparisonExp {
_eq: String
_gt: String
_gte: String
_ilike: String
_in: [String!]
_iregex: String
_is_null: Boolean
_like: String
_lt: String
_lte: String
_neq: String
_nilike: String
_nin: [String!]
_niregex: String
_nlike: String
_nregex: String
_nsimilar: String
_regex: String
_similar: String
}

Fields​

StringComparisonExp._eq ● String scalar​

StringComparisonExp._gt ● String scalar​

StringComparisonExp._gte ● String scalar​

StringComparisonExp._ilike ● String scalar​

does the column match the given case-insensitive pattern

StringComparisonExp._in ● [String!] list scalar​

StringComparisonExp._iregex ● String scalar​

does the column match the given POSIX regular expression, case insensitive

StringComparisonExp._is_null ● Boolean scalar​

StringComparisonExp._like ● String scalar​

does the column match the given pattern

StringComparisonExp._lt ● String scalar​

StringComparisonExp._lte ● String scalar​

StringComparisonExp._neq ● String scalar​

StringComparisonExp._nilike ● String scalar​

does the column NOT match the given case-insensitive pattern

StringComparisonExp._nin ● [String!] list scalar​

StringComparisonExp._niregex ● String scalar​

does the column NOT match the given POSIX regular expression, case insensitive

StringComparisonExp._nlike ● String scalar​

does the column NOT match the given pattern

StringComparisonExp._nregex ● String scalar​

does the column NOT match the given POSIX regular expression, case sensitive

StringComparisonExp._nsimilar ● String scalar​

does the column NOT match the given SQL regular expression

StringComparisonExp._regex ● String scalar​

does the column match the given POSIX regular expression, case sensitive

StringComparisonExp._similar ● String scalar​

does the column match the given SQL regular expression

Member Of​

JsonbCastExp input ● TorqueResultBoolExp input ● TorqueTraceBoolExp input