MySQL Tutorial/Comparison Functions Operators/Introduction

Comparison Functions and Operators

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.ru/doc/refman/5.1/en/index.html