> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/welcome-to-the-mysql-tutorial/sql-null-functions.md).

# SQL NULL Functions

```
mysql> SELECT IFNULL(addressLine2,'Hihi'), addressLine2 from customers;
+-----------------------------+--------------------------+
| IFNULL(addressLine2,'Hihi') | addressLine2             |
+-----------------------------+--------------------------+
| Hihi                        | NULL                     |
| Hihi                        | NULL                     |
| Level 3                     | Level 3                  |
| Hihi                        | NULL                     |
+-----------------------------+--------------------------+
```