SQL Operators in 10.5 ES
Structured Query Language (SQL) operators are keywords and symbols used to perform common arithmetic, logical, and matching operations on columns and column data.
Not equal to.
Bitwise left shift.
Less than or equal to.
Equal to without special treatment for NULL.
Equal to (if either value is NULL it returns NULL instead of 1 or 0).
Greater than or equal to.
Bitwise right shift.
Bitwise exclusive OR.
Presence in all returned rows.
Logical And. Evaluates to 1 if both operators are non-zero, 0 if one or both operators are 0, NULL if either is NULL.
Presence in any returned rows.
Compares the return value of an expression to minimum and maximum arguments. Returns 1 if expression is greater than or equal to the minimum and less than or equal to the maximum, otherwise returns 0.
Casts strings to binary values.
Performs integer division.
Presence of returned rows.
Presence of value in a list.
Boolean comparison, negative.
Performs pattern matching.
Not present within a range.
Not present in a list.
Performs pattern matching, negative.
Non-match to a Regular Expression.
Performs Regular Expression matching.
Performs Soundex matching.
Logical Exclusive Or operator. Evaluates to 1 if an one operands is non-zero, zero if both are non-zero, NULL if either is NULL.