Bug #79058 Please provide a function to search for keys in JSON values
Submitted: 1 Nov 2015 11:19 Modified: 30 Nov 2015 12:43
Reporter: Roland Bouman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: JSON Severity:S4 (Feature request)
Version:5.7.9 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[1 Nov 2015 11:19] Roland Bouman
JSON_SEARCH can be used to find paths that contain string values that match a specified pattern. 

It would be really nice to have a similar function, say, JSON_SEARCH_KEYS, that does the same for propery names. This would be especially useful for profiling JSON data and handling evolving schema structures. For example, a property like "customer-name" might initially have lived at the top-level document, but later on, as the application evolved, be moved inside a nested "customer" object. It would then be useful to be able to find the path of the "customer-name" property with a search function.

How to repeat:

Suggested fix:
Please provide a function to search for property names in JSON documents.
[30 Nov 2015 12:43] Umesh Shastry
Hello Roland,

Thank you for the feature request!