select remark from t_table where id=1;
运行SQL:
select SUBSTRING_INDEX(remark, '-', 1),SUBSTRING_INDEX(SUBSTRING_INDEX(remark,'-',2),'-',-1),SUBSTRING_INDEX(SUBSTRING_INDEX(remark,'-',-2),'-',1),
SUBSTRING_INDEX(remark, '-', -1) from t_table where id=1;
查询结果: