Learn SQL Database Programming

Comparison operators

To recap what was covered in Chapter 6, Querying a Single Table, the following table lists comparison operators:

Symbol	Description	Examples
=	equal	column = 'text' column = 1
>=	greater than or equal to	column >= 1
>	greater than	column > 1
<=	less than or equal to	column <= 1
<	less than	column < 1
<>	does not equal	column <> 'text' column <> 1
!=	does not equal	column != 'text' column != 1

Some example use cases of comparison operators are listed here:

• WHERE column = 100—This will return all rows where a column value equals 100.
• WHERE column = 'string value'—This will return all rows where a column value equals 'string value'.
• WHERE column != 1000—This will return all rows where a column ...