image.png
    LIKE可以比较二进制数据，正常不区分大小写，用二进制时区分

    运算符优先级

    1. INTERVAL
    2. BINARY COLLATE
    3. ！
    4. -负号 ~按位求反
    5. ^
    6. */DIV%MOD
    7. +-
    8. <<>>
    9. &
    10. |
    11. <<= = <=> <> != >= > IN IS LIKE REGEXP RLIKE
    12. BETWEEN CASE WHEN THEN ELSE
    13. NOT
    14. AND &&
    15. XOR
    16. OR ||
    17. :=


    NULL和任何数值计算都是NULL