This example shows how to use the JSONExtractValue method to filter results. This query gets the name of all persons older than 23.
JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$.[?(@.age > 23)].firstName') FROM my_table ORDER BY 1;
Result:
ENO edata.JSONExtractValue(…) ----------------------------- 1 Cameron 2 ? 3 Alex 4 David