ISNULL(expr)
If expr
is NULL, ISNULL() returns 1, otherwise it returns 0.
See also NULL Values in MariaDB.
SELECT ISNULL(1+1); +-------------+ | ISNULL(1+1) | +-------------+ | 0 | +-------------+ SELECT ISNULL(1/0); +-------------+ | ISNULL(1/0) | +-------------+ | 1 | +-------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/isnull/