数据库截取字符串的问题

问题:如果我想截取数据库中的1,2,3,4这种字段怎么办?并且进行排序

如:

代码:

SELECT    
		IFNULL(
			CONVERT (
				substring_index(LEFT (reason_num,char_length(case_num)-1),']',-1),SIGNED),0
			) AS reasonNum,reason_num
		FROM
			t_orm_reason
		WHERE
			is_deleted = 0
		GROUP BY
			caseNum

效果: