Sample Header Ad - 728x90

Specify range of Json array from different column

0 votes
1 answer
878 views
Mysql 8 makes it possible to extract part of an array saved in a JSON column as shown below:
jcol->>'$[1 to 5]' FROM db.table
which 1 and 5 are boundaries of the desired range of elements in array. My question is how to specify the range by numbers from different column. Some thing like this:
jcol->>'$[table2.from to table2.to]' FROM db.table
Asked by Pooya Estakhri (149 rep)
Jun 2, 2022, 05:54 AM
Last activity: Jun 2, 2022, 11:43 AM