This topic describesthe comparison operators supported by Distributed Relational Database Service (DRDS).
DRDS supports the following comparison operators.
|BETWEEN ... AND ...||Check whether a value is within a range of values|
|<=>||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|