Example: JSONExtractValue with Multiple Results

Teradata Vantage™ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

This example shows how to use the JSONExtractValue method to return multiple results. This query gets the name of any school that has a type with a value like 'college'.

JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$..schools[?(@.type == "college")].name') 
FROM my_table 
ORDER BY 1;

Result:

ENO edata.JSONExtractValue(…) 
-----------------------------
1   UCI
2   Mira Costa
3   CSUSM
4   ?