COALESCE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the first non-NULL value in the given list and NULL when all values are NULL.
EXAMPLES
SELECT COALESCE(NULL,NULL,'foo',NULL,'bar');
+--------------------------------------+
| COALESCE(NULL,NULL,'foo',NULL,'bar') |
+--------------------------------------+
| foo |
+--------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.