would anyone on this post know how to replace instra in this
select substr(caption,(instr(caption,'@') + 1 ), length(caption)), (instr(caption,'@') + 1)
FROM "CONVIVA_ANALYTICS"."INSTAGRAM_POST_METRICS"
WHERE postid = '1971324349038518078_1547775030'
ORDER BY caption;
I am trying to grab...