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