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    |
+-----------+------+
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s