Table 5. Comparison Operators
Operator |
Description |
---|---|
= |
Equal |
< |
Less than |
> |
Greater than |
<= |
Less than or equal to |
>= |
Greater than or equal to |
<> |
Not equal |
!= |
Not equal |
Example:
USE world;
SELECT name, population
FROM country
WHERE population > 1000000;
Results:
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/comparison_operators.