本文介绍了PolarDB-X 1.0支持的比较运算符。
PolarDB-X 1.0支持如下比较运算符：
| 运算符 | 描述 |
|---|---|
| BETWEEN ... AND ... | Check whether a value is within a range of values |
| = | Equal operator |
| <=> | NULL-safe equal to operator |
| > | Greater than operator |
| >= | Greater than or equal operator |
| 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 |
| < | Less than operator |
| <= | Less than or equal operator |
| LIKE | Simple pattern matching |
| NOT BETWEEN ... AND ... | Check whether a value is not within a range of values |
| !=, <> | Not equal operator |
| NOT LIKE | Negation of simple pattern matching |