Some of the other functions are as follows:
- JSON_KEYS(): Gets all the keys in a JSON document:
mysql> SELECT JSON_KEYS(details) FROM emp_details WHERE emp_no = 1;*************************** 1. row ***************************JSON_KEYS(details): ["email", "phone", "address", "nickname", "locatation"]
- JSON_LENGTH(): Gives the number of elements in a JSON document:
mysql> SELECT JSON_LENGTH(details) FROM emp_details WHERE emp_no = 1;*************************** 1. row ***************************JSON_LENGTH(details): 5