java mysql截取所需数据

mysql截取数据:

例:截取门铺名称,门铺名称长度不确定
    {"进店日期":"2022-09-01","电话":"1********25","姓名":"张三","单号":"90817","门铺":"吴滨路店","消费金额":"60"}
sql: (select substring_index(substring_index(history_data,'门铺":"',-1),'","消费金额"',1)) AS dp_name
	1. 先获取 门铺":" 最右边数据
	2. 在获取 ","消费金额" 最左边数据
	3. 最终获取 门铺名称