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 ?