tencent cloud

Feedback

Operators

Last updated: 2024-03-25 15:28:24
    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