Cheat Sheet logoCheat Sheet Today
MySQL Functions, JSON, and Date Cheatsheet/Extract a value from JSON

Read a path inside a JSON document.

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

Extract a value from JSON

sql
sql
SELECT JSON_EXTRACT(settings, '$.notifications.email') AS email_enabled FROM user_preferences;
Explanation

Returns JSON data; use `->>`-style unquoting equivalents or JSON_UNQUOTE when needed.

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
Update a JSON path
Write or replace a value inside a JSON document.
OpenIn sheetsqlsame section
Build JSON in a query
Construct a JSON object from scalar values.
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