1、如果想用mysql,则用 MySQL FIELD
2、在Java中:
List<String> corporation = Arrays.asList("全安", "查马", "实官", "施亘", "暗李");
List<String> sortRules = Arrays.asList("全安", "实官");
List<String> sorted = corporation.stream().sorted(((o1, o2) -> {
int i1 = sortRules.indexOf(o1);
int i2 = sortRules.indexOf(o2);
//把不在指定规则中的放在最后面
if (i1 < 0 || i2 < 0) {
return -(i1 - i2);
}
return i1 - i2;
})).collect(Collectors.toList());