mysql截取數據:

例:截取門鋪名稱,門鋪名稱長度不確定
    {"進店日期":"2022-09-01","電話":"1********25","姓名":"張三","單號":"90817","門鋪":"吳濱路店","消費金額":"60"}
sql: (select substring_index(substring_index(history_data,'門鋪":"',-1),'","消費金額"',1)) AS dp_name
	1. 先獲取 門鋪":" 最右邊數據
	2. 在獲取 ","消費金額" 最左邊數據
	3. 最終獲取 門鋪名稱