See Section 12.16.11, “Spatial GeoJSON Functions”. The precise outcome of the sort is subject toĬhange at any time do not rely on it to be consistent betweenĪ set of spatial functions for operating on GeoJSON values is alsoĪvailable. These values (see Normalization, Merging, and Autowrapping of JSON Values), and thus Arguments parsed as JSON areįunctions that return JSON values always perform normalization of To query a nested JSON object in MySQL, you can use the JSONEXTRACT () function to extract the value of the nested key and then use comparison operators to filter the results. The functions described in this section perform operations on JSONĭata type and additional examples showing how to use theseįunctions, see Section 11.5, “The JSON Data Type”.įor functions that take a JSON argument, an error occurs if theĪrgument is not a valid JSON value.
12.17.1 JSON Function Reference 12.17.2 Functions That Create JSON Values 12.17.3 Functions That Search JSON Values 12.17.4 Functions That Modify JSON Values 12.17.5 Functions That Return JSON Value Attributes 12.17.6 JSON Table Functions 12.17.7 JSON Schema Validation Functions 12.17.8 JSON Utility Functions
