> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/ifnull.md).

# IFNULL

## Syntax

```bnf
IFNULL(expr1,expr2)
NVL(expr1,expr2)
```

## Description

If *`expr1`* is not `NULL`, `IFNULL()` returns *`expr1`*; otherwise it returns\_`expr2`\_. `IFNULL()` returns a numeric or string value, depending on the context in which it is used.

`NVL()` is an alias for `IFNULL()`.

## Examples

```sql
SELECT IFNULL(1,0); 
+-------------+
| IFNULL(1,0) |
+-------------+
|           1 |
+-------------+

SELECT IFNULL(NULL,10);
+-----------------+
| IFNULL(NULL,10) |
+-----------------+
|              10 |
+-----------------+

SELECT IFNULL(1/0,10);
+----------------+
| IFNULL(1/0,10) |
+----------------+
|        10.0000 |
+----------------+

SELECT IFNULL(1/0,'yes');
+-------------------+
| IFNULL(1/0,'yes') |
+-------------------+
| yes               |
+-------------------+
```

## See Also

* [NULL values](/docs/server/reference/data-types/null-values.md)
* [IS NULL operator](/docs/server/reference/sql-structure/operators/comparison-operators/is-null.md)
* [IS NOT NULL operator](/docs/server/reference/sql-structure/operators/comparison-operators/is-not-null.md)
* [COALESCE function](/docs/server/reference/sql-structure/operators/comparison-operators/coalesce.md)
* [NULLIF function](/docs/server/reference/sql-functions/control-flow-functions/nullif.md)
* [CONNECT data types](/docs/server/server-usage/storage-engines/connect/connect-data-types.md#null-handling)

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}