Regular Expressions

Operator	Parameter types	Result
x [NOT] LIKE y	x - string y - string-pattern	True, if string x [not] matches pattern y. Pattern can contain any string value. There are two service symbols in pattern: '_' - matches any single symbol or nothing '%' - matches any sequence of symbols or nothing
x REGEX y	x - string y - string-pattern	True if string x matches pattern y
x ALMOST [LIKE] y [WITHIN z]	x - string or number y - string or number z - maximum distance between strings, integer	True if string is within a specified distance. Levenshtein distance is used as a metric to determine the distance between strings. For example, the Levenshtein distance between "kitten" and "sitting" is 3, since the following three edits change one into the other, and there is no way to do it with fewer than three edits: 1. kitten > sitten (substitution of 's' for 'k') 2. sitten > sittin (substitution of 'i' for 'e') 3. sittin > sitting (insert 'g' at the end). Distance between numbers is measured as abs(x-y)
x [NOT] IN (a,b,c,.)	x,a,b,c,. - any type values	True if x in enum
x [NOT] BETWEEN a AND b	x, a, b - numeric or string type values	True if value [not] resides in range between a and b