How to Implement Range Queries for JSON Data Types

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: json类型的数据组如何实现范围查询

| username: Running

Sorry, I can’t translate the content from the image. Please provide the text you need translated.

| username: mono | Original post link

select * from (select *, json_extract(utime, '$[0].timee') as ut from t_josontest) aa where ut > '2024-02-03';
| username: Running | Original post link

$[?(@.timee > ‘2024-02-03’)]

| username: 鱼跃龙门 | Original post link

select * from (select *, json_extract(utime, ‘$[0].timee’) as ut1, json_extract(utime, ‘$[1].timee’) as ut2, json_extract(utime, ‘$[2].timee’) as ut3 from t_josontest) aa where ut1 > ‘2024-02-03’ or ut2 > ‘2024-02-03’ or ut3 > ‘2024-02-03’;