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