mysql in有排序

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago');

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago') ORDER BY age ASC;

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    city VARCHAR(50),
    age INT
);

INSERT INTO users (id, name, city, age) VALUES
(1, 'Alice', 'New York', 30),
(2, 'Bob', 'Los Angeles', 25),
(3, 'Charlie', 'Chicago', 35),
(4, 'David', 'New York', 40);

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago') ORDER BY age ASC;