Map values with CASE

sql

SELECT id,
  CASE status
    WHEN 'paid' THEN 'Paid'
    WHEN 'pending' THEN 'Pending'
    ELSE 'Other'
  END AS status_label
FROM orders;

Explanation

`CASE` is essential for SQL-side normalization and reporting.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing json and string functions

Read a path inside a JSON document.

Open In sheetsqlsame section

Write or replace a value inside a JSON document.

Open In sheetsqlsame section

Construct a JSON object from scalar values.

Open In sheetsqlsame section

Join scalar values into one string.

Open In sheetsqlsame section

Return the first non-NULL expression.

Open In sheetsqlsame section

Return current timestamp values.