AnrDaemon
Продвинутый новичок
Код:
DROP TABLE IF EXISTS `testtable`;
CREATE TABLE `testtable` (`field` TEXT);
INSERT INTO `testtable` VALUES
('{"order":1}'),
('{"order":11}'),
('{"order":2}');
SELECT MAX(field->'$.order'), MAX(field->>'$.order') FROM testtable;
+-----------------------+------------------------+
| MAX(field->'$.order') | MAX(field->>'$.order') |
+-----------------------+------------------------+
| 11 | 2 |
+-----------------------+------------------------+