Example 1
Display a fallback value when nickname is null
If nickname is null, the expression falls back to the literal 'anonymous'.
Source table data Rows loaded before the example query runs.
Setup
CREATE TABLE members (id INT, nickname VARCHAR(50));
INSERT INTO
members (id, nickname)
VALUES
(1, 'ace'),
(2, NULL);Validated query Shared across supported engines.
SQL
SELECT
id,
COALESCE(nickname, 'anonymous') AS display_name
FROM
members
ORDER BY
id;Expected result Returned rows for the shared example.
| id | display_name |
|---|---|
| 1 | ace |
| 2 | anonymous |
`COALESCE` behaves consistently across the supported engines in this example.