Comparison Functions,Tests, Branching : Define Function « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Define Function

Comparison Functions,Tests, Branching

       

COALESCE(x, y, z, ...)         Returns the first parameter that is not NULL.
GREATEST(x, y, z, ...)         Returns the greatest value or greatest character string.
IF(expr, val1, val2)           Returns val1 if expr is true; otherwise, val2.
IFNULL(expr1, expr2)           Returns expr2 if expr1 is NULL; otherwise, expr1.
INTERVAL(x, n1, n2, ...)       Returns 0 if x<n1; 1 if x< n2, etc.; all parameters must be integers, and n1 < n2 < ... must hold.
ISNULL(x)                      Returns 1 or 0, according to whether x IS NULL holds.
LEAST(x, y, z, ...)            Returns the smallest value or smallest character string.
STRCMP(s1, s2)                 Returns 0 if s1=s2 in sort order, -1 if s1<s2, 1 if s1>s2.








Related examples in the same category

1.Define function in C and call by SQL
2.Arithmetic Functions
3.Calculating, Formatting, and Transformation Functions