mysql中有没有一个函数可以对 json 场？

SELECT new FROM mytable
["orange", "apple"]

==>排序json数组

SELECT SORTED(new) FROM mytable
["apple", "orange"]