What are the Comparation Opreators in MySql
The comparison operators in MySQL will test if two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.
Table of comparison operators
| Comparison Operator | Value |
|---|---|
| = (Equals) | Equal to |
| (Greater Than) | Greater than |
| < (Less Than) | Less than |
| = (Greater Than or Equal To) | Greater than or equal to |
| <= (Less Than or Equal To) | Less than or equal to |
| < (Not Equal To) | Not equal to |
| != (Not Equal To) | Not equal to (not ISO standard) |
| !< (Not Less Than) | Not less than (not ISO standard) |
| ! (Not Greater Than) | Not greater than (not ISO standard) |
