1.6

Comparison Operators

Comparison Operators

  • Comparison operators compare two expressions.
  • The result of a comparison results to true or false.
  • Comparison operators are not case sensitive and are used with text and dates as well as numbers.

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:

comparison_operators.png

This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/comparison_operators.