tencent cloud

Feedback

Operators

Last updated: 2019-10-25 16:04:52

    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
    Contact Us

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

    Technical Support

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

    7x24 Phone Support