Is there a way for mysql to return data in the specified order. For example, I want to search id1, 2, and 3 data. Whether written as whereidin (, 3) or whereidin (, 2), mysql returns results in the order of 1, 2, 3. Can you specify that mysql is returned in the order of 1, 3... is there a way for mysql to return data in the specified order.
For example, I want to search for data with id = 1, 2, and 3.
Whether it is written as where id in (, 3) or where id in (, 2), mysql returns results in the order of 1, 2, and 3, can I specify that mysql returns results in the order of 1, 3, and 2?
Reply content:
Is there a way for mysql to return data in the specified order.
For example, I want to search for data with id = 1, 2, and 3.
Whether it is written as where id in (, 3) or where id in (, 2), mysql returns results in the order of 1, 2, and 3, can I specify that mysql returns results in the order of 1, 3, and 2?
SELECT id, name
FROM mytable
WHERE name IN ('B', 'A', 'D', 'E', 'E', 'C ')
Order by field (name, 'B', 'A', 'D', 'E', 'C ')