MySQL in a Nutshell, 2nd Edition

Name

LEAST()

Synopsis

LEAST(value, value, ...)

Use this function to compare two or more values and return the smallest value. In an INTEGER datatype context, all values are treated as integers for comparison. In a REAL data type context, all values are treated as REAL values for comparison. If any parameter contains a case-sensitive string (i.e., with a BINARY keyword), all values are compared as case-sensitive strings. Here is an example:

SELECT LEAST(col1, col2, col3);