SQL · JSON functions

json_extract()

Reads a value from a JSON document using a path.

sqlRunnable example sql course

Syntax

json_extract(json, path)

Example

Open in the lab

SELECT json_extract('{"course":"CSS","lessons":16}', '$.course') AS course;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.