实际上,这样更好:
SELECt * FROM your_tableWHERe id IN (5,2,6,8,12,1)ORDER BY FIELD(id,5,2,6,8,12,1);
这是FIELD文档:
http://dev.mysql.com/doc/refman/5.0/zh-CN/string-
functions.html#function_field

实际上,这样更好:
SELECt * FROM your_tableWHERe id IN (5,2,6,8,12,1)ORDER BY FIELD(id,5,2,6,8,12,1);
这是FIELD文档:
http://dev.mysql.com/doc/refman/5.0/zh-CN/string-
functions.html#function_field