JSON_EXTRACT_PATH_TEXT¶

JSON_EXTRACT_PATH_TEXT(data, path)

Parses the string data as if it were JSON data, then extracts values from within (possibly multiple times if the data is nested) using the string path.