运算符
更新时间：2024-02-21
GaiaDB-X支持运算符，如下：
| 运算符 | 描述 |
|---|---|
| & | Bitwise AND |
| > | Greater than operator |
| >> | Right shift |
| >= | Greater than or equal operator |
| < | Less than operator |
| <>, != | Not equal operator |
| << | Left shift |
| <= | Less than or equal operator |
| <=> | NULL-safe equal to operator |
| %, MOD | Modulo operator |
| * | Multiplication operator |
| + | Addition operator |
| - | Minus operator |
| - | Change the sign of the argument |
| -> | Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). |
| ->> | Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). |
| / | Division operator |
| = | Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) |
| = | Equal operator |
| ^ | Bitwise XOR |
| AND, && | Logical AND |
| BETWEEN ... AND ... | Whether a value is within a range of values |
| BINARY | Cast a string to a binary string |
| CASE | Case operator |
| DIV | Integer division |
| IN() | Whether a value is within a set of values |
| IS | Test a value against a boolean |
| IS NOT | Test a value against a boolean |
| IS NOT NULL | NOT NULL value test |
| IS NULL | NULL value test |
| LIKE | Simple pattern matching |
| NOT, ! | Negates value |
| NOT BETWEEN ... AND ... | Whether a value is not within a range of values |
| NOT IN() | Whether a value is not within a set of values |
| NOT LIKE | Negation of simple pattern matching |
| NOT REGEXP | Negation of REGEXP |
| OR, || | Logical OR |
| REGEXP | Whether string matches regular expression |
| RLIKE | Whether string matches regular expression |
| SOUNDS LIKE | Compare sounds |
| XOR | Logical XOR |
| | | Bitwise OR |
| ~ | Bitwise inversion |
相比MySQL5.7，GaiaDB-X暂不支持的运算符，如下
| 运算符 | 描述 |
|---|---|
| := | Assign a value |