Operators
Amazon S3 Select support the following operators.
Logical Operators
-
AND
-
NOT
-
OR
Comparison Operators
-
<
-
>
-
<=
-
>=
-
=
-
<>
-
!=
-
BETWEEN
-
IN
– For example:IN ('a', 'b', 'c')
Pattern Matching Operators
-
LIKE
-
_
(Matches any character) -
%
(Matches any sequence of characters)
Unitary Operators
-
IS NULL
-
IS NOT NULL
Math Operators
Addition, subtraction, multiplication, division, and modulo are supported.
-
+
-
-
-
*
-
/
-
%
Operator Precedence
The following table shows the operators' precedence in decreasing order.
Operator/Element | Associativity | Required |
---|---|---|
- | right | unary minus |
*, /, % | left | multiplication, division, modulo |
+, - | left | addition, subtraction |
IN | set membership | |
BETWEEN | range containment | |
LIKE | string pattern matching | |
<> | less than, greater than | |
= | right | equality, assignment |
NOT | right | logical negation |
AND | left | logical conjunction |
OR | left | logical disjunction |