Cheat Sheet logoCheat Sheet Today
MySQL Functions, JSON, and Date Cheatsheet/Build JSON in a query

Construct a JSON object from scalar values.

Back to sheetBrowse commands
Sign in to save
Section: json and string functions

Build JSON in a query

sql
sql
SELECT JSON_OBJECT('id', id, 'email', email) AS user_json FROM users LIMIT 5;
Explanation

Helpful for API prototyping, exports, and SQL-side reshaping.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing json and string functions
Extract a value from JSON
Read a path inside a JSON document.
OpenIn sheetsqlsame section
Update a JSON path
Write or replace a value inside a JSON document.
OpenIn sheetsqlsame section
Concatenate strings
Join scalar values into one string.
OpenIn sheetsqlsame section
Use COALESCE for fallback values
Return the first non-NULL expression.
OpenIn sheetsqlsame section
Map values with CASE
Transform values into labels inside a query.
OpenIn sheetsqlsame section
Get the current date and time
Return current timestamp values.
OpenIn sheetsql