MySQL + SQL · Lesson 61

IFNULL and COALESCE in MySQL

Handling NULL Values

IFNULL and COALESCE replace NULL with a default value, so reports look clean.

IFNULL(value, default)

SELECT name, IFNULL(phone, 'Not given') AS phone
FROM students;
If phone is NULL, it shows "Not given" instead.

COALESCE(a, b, c, ...)

Returns the first non-NULL value from the list.

SELECT COALESCE(mobile, landline, 'No contact') AS contact
FROM students;

Summary

  • IFNULL replaces NULL with one default.
  • COALESCE picks the first non-NULL from many options.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.