Comparison operations result in a value of 1 (TRUE), 0 (FALSE), or NULL.
Comparison Functions and Operators work for both numbers and strings.
Strings are converted to numbers and numbers to strings as necessary.
By default, string comparisons are not case sensitive and use the current character set.
| Name | Description |
| BETWEEN AND | Check whether a value is within a range of values |
| COALESCE() | Return the first non-NULL argument |
| <=> | NULL-safe equal to operator |
| = | Equal operator |
| >= | Greater than or equal operator |
| > | Greater than operator |
| GREATEST() | Return the largest argument |
| IN | Check whether a value is within a set of values |
| INTERVAL() | Return the index of the argument that is less than the first argument |
| IS NULL | NULL value test |
| IS | Test a value against a boolean |
| ISNULL() | Test whether the argument is NULL |
| LEAST() | Return the smallest argument |
| <= | Less than or equal operator |
| < | Less than operator |
| LIKE | Simple pattern matching |
| NOT BETWEEN ... AND ... | Check whether a value is not within a range of values |
| !=, <> | Not equal operator |
| NOT IN | Check whether a value is not within a set of values |
| NOT LIKE | Negation of simple pattern matching |
| SOUNDS LIKE | Compare sounds |
Quote: dev.mysql.com/doc/refman/5.1/en/index.html
| 15.1.Introduction |
| 15.1.1. | Comparison Functions and Operators |