String_comparison_exp

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

Input 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