is there anyway to sort the returned rows by ID used in IN clause?, i wanted the sorting to be preserved, but apparently by default i sort niya ang row, and you cant use ORDER BY since i wanted it to be preserved..Code:Table +----+------------+ | ID | Name | +----+------------+ | 1 | Data 1 | | 2 | Data 2 | | 3 | Data 3 | +----+------------+ SELECT * FROM Table WHERE ID IN ('2','3','1') my expected result +----+------------+ | ID | Name | +----+------------+ | 2 | Data 2 | | 3 | Data 3 | | 1 | Data 1 | +----+------------+ actual result +----+------------+ | ID | Name | +----+------------+ | 1 | Data 1 | | 2 | Data 2 | | 3 | Data 3 | +----+------------+