mysql - 选择 - MySQL 中按单词排序？

Question

MySQL中有没有按Word排序的方法？

例如:

SELECT *  FROM `table` WHERE `batch` = 'something' AND outcome in ('Business','Professional', 'Consumer')

我想要按顺序获取行列表:商业、专业，然后消费者，而不是字母顺序。

Answer 1

试试这个:

SELECT *  
FROM `table` 
WHERE `batch` = 'something' 
       AND outcome in ('Business','Professional', 'Consumer')
ORDER BY 
   CASE WHEN outcome  = 'Business'     THEN 1
        WHEN outcome  = 'Professional' THEN 2
        WHEN outcome  = 'Consumer'     THEN 3
        ELSE 4
   END