IF and IFNULL in SQL

IF and IFNULL in SQL — a practical guide to SQL IF IFNULL with clear examples you can reuse in real projects.

SQL Tutorial Series (45/100). Prefer one article? Read the complete SQL tutorial.

Short description

Prefer COALESCE for portable null-handling across engines.

IF / IFNULL (MySQL)

SELECT IF(stock > 0, 'In stock', 'Sold out') AS availability,
       IFNULL(nickname, name) AS display_name
FROM products;