JSON Path is a path expression language similar to XPath to select values inside a JSON value

The following json_exists() call would return all rows from the table where the JSON column contains at least one array element in the array "orders" that has a key "num_pieces" with a value greater than 10

select *
from some_table
where json_exists(json_column, '$.orders[*] ? (@.num_pieces > 10)');

Back to the SQL Feature Comparison