Home » MySQL Comparison Functions

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.
MySQL BIT_XOR() Function
Previously
MySQL BIT_XOR() Function
Up Next
MySQL GREATEST and LEAST
MySQL GREATEST and LEAST