How to get a product's custom option's value in a particular order via SQL?

Administration
, ,
1 
SET @optionTitle = 'IRIDIUM PHONE OR SIM #';
SET @orderId = 54103;
SELECT JSON_UNQUOTE(JSON_EXTRACT(product_options,  JSON_UNQUOTE(REPLACE(
	(SELECT JSON_SEARCH(product_options,  'all', @optionTitle) FROM sales_order_item WHERE @orderId = order_id)
	,'.label', '.option_value'
))))
FROM sales_order_item WHERE @orderId = order_id;

01