Skip to content

Glossary: SQL Beyond the Basics

Path (JSON)

Also written: path

Where to look inside JSON, such as '$.notes[1]'. Here $ is the whole value, .notes a name inside it, and [1] the second list item, since counting starts at 0.

Where the book teaches it

Related terms

JSONjson_extract->> (JSON operator)