Mysql - You could specify columns in ORDER BY clause, using their position number

select * from fe_user where uid in (“3,5,1″) order by field(uid,”3,5,1”) ;

You will get out put of above query in order by uid.

+-----------+------+
| name      | uid  |
+-----------+------+
| Dhara     | 3    |
| Jainish   | 5    |
| Senjaliya | 1    |
+-----------+------+