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

# IF function

## `IF(expr1,expr2,expr3)`

If`expr1`*\_is*`TRUE`*(*`expr1`*<> 0and*`expr1`*<> NULL),*[`IF()`](https://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html#function_if)*returns*`expr2`*. Otherwise, it returns*`expr3`.