MySQL Comparison Operators
Overview
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 |
= | Equal to |
< | Less than |
<= | Less than or equal to |
<=> | Equal to (works even for NULL values) |
<> or != | Not equal to |
> | Greater than |
>= | 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
- ANY
- ALL
- SOME
- EXISTS/ NOT EXISTS
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: