mysql jsonArray怎么查询排序

jsonArray如下：
{"recodeInfo":
[
{"orderId": "1", "userName": "张三1", "insertDate": "2018-01-27", "recordText": "测试1"},
{"orderId": "1", "userName": "李四2", "insertDate": "2018-04-02", "recordText": "测试2"}
]
}

我需要根据InsertDate获取最后一条数据

//转成list
List list = new ArrayList ();
JSONObject jsonObj = null;
for (int i = 0; i < jsonArr.size(); i++) {
jsonObj = (JSONObject)jsonArr.get(i);
list.add(jsonObj);
}
Collections.sort(list,new MyComparator());
jsonArr.clear();
for (int i = 0; i < list.size(); i++) {
jsonObj = list.get(i);
jsonArr.add(jsonObj);
}
//jsonArr排序

不是的，我是想问mysql有没有sql函数，

SELECT session_record->"$**.orderId" AS id,session_record->"$**.recordText" AS recordText,session_record,insert_date FROM mcp4500 WHERE follow_record_id='1' ORDER BY insert_date DESC

SELECT

S.*

FROM

vw_Student AS S

ORDER BY

S.Class ASC

,S.BirthDate DESC;

你是说这样子的吗？