I am trying to use SUBSTRING_INDEX to select a string between 2 values, I need the second delimiter to be the first occurrence after the first delimiter because there are a random number of occurrence of the delimiter

I hope that makes sense

This is what I have got so far

SET @initials := 'appear)","value":"';
SET @initialsE := '"';

SELECT
sales_order_item.product_options,
    SUBSTRING_INDEX(SUBSTRING_INDEX(sales_order_item.product_options,@initialsE,1),@initials,-1) AS 'Name'
FROM
    sales_order_grid
    INNER JOIN
    sales_order_item
    ON 
        sales_order_item.order_id = sales_order_grid.entity_id