MySQL Comparison Functions

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