In this tutorial, we will learn about MySQL Comparison Operators with examples.
MySQL Comparison Operators
Comparison Operators are used to compare the column value expressions.
|MySQL Comparison Operator||Description|
|<=||Less than or equal to|
|<=>||Equal to (works even for NULL values)|
|<> or !=||Not equal to|
|>=||Greater than or equal to|
|BETWEEN..AND..||Indicate a range of values|
Operators in WHERE constructs
WHERE constructs that are commonly used in the WHERE clause for comparisons against a column and a subquery are as follows:
- IN/NOT IN
- EXISTS/ NOT EXISTS
MySQL Tutorials on this website:
For more information on MySQL Database: