mysql中自定义排序_mysql自定义排序

I have a query like this: SELECT * FROM table WHERE id IN (2,4,1,5,3);

However, when I print it out, it's automatically sorted 1,2,3,4,5. How can we maintain the order (2,4,1,5,3) without changing the database structure?

Thanks!

解决方案

i ask this :

the answers that i get and all the credit belong to them is :

You can use a CASE operator to specify the order:

SELECT * FROM table

WHERE id IN (3,6,1,8,9)

ORDER BY CASE id WHEN 3 THEN 1

WHEN 6 THEN 2

WHEN 1 THEN 3

WHEN 8 THEN 4

WHEN 9 THEN 5

END

in php u can do it like :

$my_array = array (3,6,1,8,9) ;

$sql = 'SELECT * FROM table WHERE id IN (3,6,1,8,9)';

$sql .= "\nORDER BY CASE id\n";

foreach($my_array as $k => $v){

$sql .= 'WHEN ' . $v . ' THEN ' . $k . "\n";

}

$sql .= 'END ';

echo $sql;

?>