×
Night mode
Sign up
Login
JSON_EXTRACT
Extracts values from JSON object. In this example we extract two values: 
number
, 
issue_date
SELECT
    document_details,
    JSON_EXTRACT(document_details, '$.number'),
    JSON_EXTRACT(document_details, '$.issue_date'),
    JSON_UNQUOTE(JSON_EXTRACT(document_details, '$.issue_date'))
FROM students
Note: We can use 
JSON_UNQUOTE()
function to remove quotes around JSON string values
by Valeri Tandilashvili
4 years ago
MySQL
JSON
Full MySQL Course for Beginners
2
Pro tip: use ```triple backticks around text``` to write in code fences