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
Last activity: Jun 2, 2022, 11:43 AM