15.10 - Example: JSONExtractValue with Multiple Results - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

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   ?