WHERE clauses

Use comparison operators, logical operators, and value operators in WHERE clauses.
Table 1. Supported operators in WHERE clauses
Type Operators
Comparison operators <, <=, >, >=, =, <>
Logical operators AND, OR,NOT
Value operators IN, LIKE, BETWEEN, IS NULL