clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1228817 fiddles created (16683 in the last week).

SELECT shop_id,SUBSTRING(my_string, CHARINDEX(':"',my_string)+2, CHARINDEX('price',my_string, CHARINDEX('price',my_string)+1) - CHARINDEX(':"',my_string)-2) as My_String ,SUBSTRING(my_string, CHARINDEX('from',my_string) + 4, CHARINDEX('to',my_string) - CHARINDEX('from',my_string) - 4) as [From] ,SUBSTRING(my_string, CHARINDEX('to',my_string)+2, CHARINDEX('"}',my_string) - CHARINDEX('to',my_string)-2) as [From] FROM ( SELECT 10048586 AS shop_id,'{"priceChange":"item price change from 88.0 to 98.0"}' AS my_string UNION ALL SELECT 10050114,' {"priceChange":package price change from 0.8 to 1.0"}' UNION ALL SELECT 10036306,'{"priceChange":"item price change from 19.0 to 21.0"}' )X
shop_id My_String From From
10048586 item 88.0 98.0
10050114 {"priceChange":package 0.8 1.0
10036306 item 19.0 21.0
 hidden batch(es)