JSON_MIN
The JSONMIN function returns the smallest in an array of numbers.
Syntax
JSON_MIN(json, jsonpath)
Example
The following example returns the smallest number in the array:
SELECT JSON_MIN(JSON_ARRAY(1, 2, 3),'$') json
FROM /shared/examples/ds_orders/tutorial/customers
WHERE customerid = 10
Result: 1