跳到主要内容

Conditional Functions

Introduced: v1.2.152
FunctionDescriptionExampleResult
GREATEST(value1, value2, ...)Returns the maximum value from a set of values.GREATEST(5, 9, 4)9
LEAST(value1, value2, ...)Returns the minimum value from a set of values.LEAST(3, 7, 2)2
IF(cond1, expr1, [cond2, expr2, ...], expr_else)If cond1 is TRUE, it returns expr1. Otherwise if cond2 is TRUE, it returns expr2, and so on.IF(1 > 2, 3, 4 < 5, 6, 7)6
IFNULL(expr1, expr2)Returns expr1 if it is not NULL. Otherwise return expr2. They must have the same data type.IFNULL(0, NULL)0
value [ NOT ] IN (value1, value2, ...)Checks whether value is (or is not) one of the members of an explicit list.1 not in (2, 3)1(TRUE)
expr1 IS [ NOT ] DISTINCT FROM expr2Compares whether two expressions are equal (or not equal) with awareness of nullability, meaning it treats NULLs as known values for comparing equality.NULL is distinct from NULL0(FALSE)
IS_NOT_NULL(expr)Checks whether the value is not NULL.IS_NOT_NULL(1)1(TRUE)
IS_NULL(expr)Checks whether the value is NULL.IS_NULL(1)0(FALSE)
NULLIF(expr1, expr2)Returns NULL if two expressions are equal. Otherwise return expr1. They must have the same data type.NULLIF(0, NULL)0
这篇文章对您有帮助吗?
Yes
No