SELECT buildingFloors FROM ConstructionCase ORDER BY FIELD(SUBSTRING(buildingFloors,1,1),'一','二','三','四','五','六','七','八','九') ;
标签:buildingFloors,一二三四五,SUBSTRING,FIELD,mysql,排序 From: https://www.cnblogs.com/kdx-2/p/17175374.html
SELECT buildingFloors FROM ConstructionCase ORDER BY FIELD(SUBSTRING(buildingFloors,1,1),'一','二','三','四','五','六','七','八','九') ;
标签:buildingFloors,一二三四五,SUBSTRING,FIELD,mysql,排序 From: https://www.cnblogs.com/kdx-2/p/17175374.html