I am looking for function/query that can search in JSON type data against array of values. Json can have nested keys. I tried using JSON_SEARCH or JSON_CONTAINS . getting Undefined function:
JSON_SEARCH(data->'$[*]', JSON_ARRAY("abc"))
Is there a way to search in JSON object keys for list of values ? for e.g :
JSON col data {"name":"Back","address":{"location":{"country":[{"city":{"state":[‘jkl’,’fgh’]},"type":"home"},"empId":"e100043867","FullName":"Back"}
JSON_ARRAY = [‘name’,’state’,’country’]
check if JSON_ARRAY values exists in JSON data ?
Any help would be appreciated.