mysql - 如何让ORDER BY识别出S的值大于A？

Question

我想使用 ORDER BY ASC 对 stats 表中的列进行排序。我希望 sql 将 S 识别为大于 A。是否有某种重新分配值的方法？我希望下面的代码打印:“S，A，A，B”，以便 S>A 但其余的都是按字母顺序排列的。 sql新手，谢谢。编辑:我很抱歉，但我忘了包括我试图通过以下方式组织的内容:从统计数据中选择稀有度 ORDER BY 稀有度 ASC;

CREATE TABLE stats (
    _name VARCHAR(50) NOT NULL,
    refreshingness INT UNSIGNED NOT NULL,
    flavor INT UNSIGNED NOT NULL,
    chuggability INT UNSIGNED NOT NULL,
    rarity VARCHAR(1)CHARACTER SET LATIN1 NOT NULL,
    PRIMARY KEY (_name)
);

SELECT rarity FROM stats
ORDER BY rarity ASC;

INSERT INTO stats(_name,refreshingness,flavor,chuggability,rarity)
VALUES("Southern Style Sweet Tea",2,3,3,"S");

INSERT INTO stats(_name,refreshingness,flavor,chuggability,rarity)
VALUES("Raspberry",4,3,4,"A");

INSERT INTO stats(_name,refreshingness,flavor,chuggability,rarity)
VALUES("Iced Tea with Gingseng Zero",4,3,4,"A");

INSERT INTO stats(_name,refreshingness,flavor,chuggability,rarity)
VALUES("Half & Half Pink Tea Lemonade",2,2,2,"B");

Answer 1

这是您的查询。您可以在order by数字上使用case，因为数字始终排在第一位。

SELECT * FROM stats ORDER BY 
    CASE WHEN rarity = 'S' THEN 1 
    ELSE rarity END

参见dbfiddle