Skip to main content
Version: 4.2.0

String_comparison_exp

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

input String_comparison_exp {
_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​

_eq (String)​

_gt (String)​

_gte (String)​

_ilike (String)​

does the column match the given case-insensitive pattern

_in ([String!])​

_iregex (String)​

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

_is_null (Boolean)​

_like (String)​

does the column match the given pattern

_lt (String)​

_lte (String)​

_neq (String)​

_nilike (String)​

does the column NOT match the given case-insensitive pattern

_nin ([String!])​

_niregex (String)​

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

_nlike (String)​

does the column NOT match the given pattern

_nregex (String)​

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

_nsimilar (String)​

does the column NOT match the given SQL regular expression

_regex (String)​

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

_similar (String)​

does the column match the given SQL regular expression