Comparison operators are used in the WHERE clause to determine which records to select.
| Comparison Operator | Description |
|---|---|
| = | Equal |
| <> | Not Equal |
| != | Not Equal |
| > | Greater Than |
| >= | Greater Than or Equal |
| < | Less Than |
| <= | Less Than or Equal |
| IN | Matches a value in a list |
| NOT | Negates a condition |
| BETWEEN | Within a range (inclusive) |
| EXISTS | Condition is met if subquery returns at least one row |
[//]: # https://www.techonthenet.com/sql/comparison_operators.php