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.
Operator |
Description |
---|---|
See NOT |
|
Not equal to. |
|
Modulo. |
|
Bitwise AND. |
|
See AND |
|
Multiply. |
|
Add. |
|
Subtract. |
|
Divide. |
|
Assign value. |
|
Less than. |
|
Bitwise left shift. |
|
Less than or equal to. |
|
Equal to without special treatment for NULL. |
|
See "!=" |
|
Equal to (if either value is NULL it returns NULL instead of 1 or 0). |
|
Greater than. |
|
Greater than or equal to. |
|
Bitwise right shift. |
|
Bitwise exclusive OR. |
|
Bitwise OR. |
|
See OR |
|
Bitwise not. |
|
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. |
|
Boolean comparison, negative. |
|
Performs pattern matching. |
|
Modulo. |
|
Logical not. |
|
Not present within a range. |
|
Not present in a list. |
|
Performs pattern matching, negative. |
|
Non-match to a Regular Expression. |
|
Logical Or. |
|
Performs Regular Expression matching. |
|
See REGEXP |
|
See ANY. |
|
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. |