Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

12.17 JSON Functions

The functions described in this section perform operations on JSON values. For discussion of theJSON data type and additional examples showing how to use these functions, seeSection 11.5, “The JSON Data Type”.

For functions that take a JSON argument, an error occurs if the argument is not a valid JSON value. Arguments parsed as JSON are indicated byjson_doc; arguments indicated byval are not parsed.

Functions that return JSON values always perform normalization of these values (seeNormalization, Merging, and Autowrapping of JSON Values), and thus orders them.The precise outcome of the sort is subject to change at any time; do not rely on it to be consistent between releases.

Unless otherwise indicated, the JSON functions were added in MySQL 5.7.8.

A set of spatial functions for operating on GeoJSON values is also available. SeeSection 12.16.11, “Spatial GeoJSON Functions”.