I have list of pages visited by a user as json array in a json column.If given a page, i want to find to next page visited from this page. Currently we are using like arrayindexofstring(json_extract_scalar(page_list,'$[*]','STRING_ARRAY'),'
abc.com/') +1, but is consumes more time. So wanted to know, if there is any straight forward way to find the index.