Mega Code Archive

 

Categories / MySQL Tutorial / Comparison Functions Operators

 

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. NameDescription BETWEEN ANDCheck 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 INCheck whether a value is within a set of values INTERVAL()Return the index of the argument that is less than the first argument IS NULLNULL value test ISTest 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 LIKESimple pattern matching NOT BETWEEN ... AND ...Check whether a value is not within a range of values !=, Not equal operator NOT INCheck whether a value is not within a set of values NOT LIKENegation of simple pattern matching SOUNDS LIKECompare sounds Quote: dev.mysql.com/doc/refman/5.1/en/index.html