MySQL Comparison Functions
- COALESCE – return the first non-NULL arguments, which is very handy for substitution of
NULL. - GREATEST & LEAST – take
narguments and return the greatest and least values of thenarguments respectively. - ISNULL – return 1 if the argument is
NULL, otherwise, return zero.