tencent cloud

All product documents
Cloud Object Storage
DocumentationCloud Object StorageDeveloper GuideData Management Data Extraction Operators
Operators
Download PDF
Last updated: 2024-03-25 15:28:24
Operators
Last updated: 2024-03-25 15:28:24
Download PDF
COS Select supports the following operators:
Operator Type
Operator
Logical operator
AND, NOT, OR
Comparison operator
<, >, <= ,>= , = , <>, !=, BETWEEN, IN, such as IN ('a', 'b', 'c')
Pattern matching operator
LIKE
Mathematical operator
+, -, *, %

Priority of Operators

The following table shows the priority of operators in descending order:
Operator/Element
Association
Use Case
-
Right
Unary subtraction
*, /, %
Left
Multiplication, division, and modulo
+, -
Left
Addition and subtraction
IN
-
Setting membership
BETWEEN
-
In the range of ()
LIKE
-
String pattern matching
<>
-
Less than and greater than
=
Right
Equivalence and assignment
NOT
Right
Logical NOT
AND
Left
Logical AND
OR
Left
Logical OR
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon