Ayuda: SELECT con ORDER BY

[huesos52]

Código mysql:

mysql> select *from numeros;
+------+
| id   |
+------+
| 7    |
| 4    |
| 9    |
| 3    |
+------+
4 rows in set (0.00 sec)
 
mysql> select *from numeros where id in('7','3','9','4');
+------+
| id   |
+------+
| 7    |
| 4    |
| 9    |
| 3    |
+------+
4 rows in set (0.00 sec)
 
mysql> select *from numeros where id in('7','3','9','4') order by field(id,'7','3','9','4');
+------+
| id   |
+------+
| 7    |
| 3    |
| 9    |
| 4    |
+------+
4 rows in set (0.00 sec)
 

La ultima consulta es la que funciona.

saludos