按SQL IN()子句中的值顺序排序

SELECT column1, column2
FROM table_name
WHERE column1 IN (value1, value2, value3)
ORDER BY CASE column1
    WHEN value1 THEN 1
    WHEN value2 THEN 2
    WHEN value3 THEN 3
END;

SELECT column1, column2
FROM table_name
WHERE column1 IN (value1, value2, value3)
ORDER BY FIELD(column1, value1, value2, value3);

CREATE TEMPORARY TABLE temp_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    column1 VARCHAR(255)
);

INSERT INTO temp_table (column1) VALUES ('value1'), ('value2'), ('value3');

SELECT t.column1, t.column2
FROM table_name t
JOIN temp_table tt ON t.column1 = tt.column1
ORDER BY tt.id;