Part 14: Comparison Operators: =, <>, !=, <, <=, >, >=
Comparison operators evaluate expressions and return TRUE, FALSE, or NULL.
1. Comparison Operator Table
| Operator | Meaning | Example |
|---|---|---|
= |
Equal to | status = 'active' |
<> or != |
Not equal to (<> is standard ANSI) |
status <> 'archived' |
< |
Less than | stock < 10 |
<= |
Less than or equal to | price <= 49.99 |
> |
Greater than | rating > 4.5 |
>= |
Greater than or equal to | age >= 18 |
Key Takeaways
- Use
<>for standard ANSI compliance, though!=is supported by most engines.
In Part 15, we will explore Logical Operators: AND, OR, and NOT (Precedence Rules)!