By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab( tickets JSON );
INSERT INTO tab VALUES
('["121","122","123"]');
SELECT JSON_EXTRACT(tickets,
JSON_UNQUOTE(JSON_SEARCH(tickets, 'one', "123"))
) AS Result,
JSON_UNQUOTE(JSON_SEARCH(tickets, 'one', "123")) AS Related_Index
FROM tab
| Result | Related_Index |
|---|---|
| "123" | $[2] |