How to order the ORDER BY using the IN() mysql?

Asked Jan 03 '17 at 10:10

Active Jan 03 '17 at 10:10

Viewed 72 times

I need to order the results by how the values in IN() clause are set up, here is the example code.

SELECT nickname, age WHERE id IN(3, 1, 2) ORDER BY ?; <- this is where I need the results go back according to the IN() clause

This the result as of now, (using PHPmyadmin, not yet php coded).

nickname | age | true id of the row
j        | 11  | 1
jj       | 22  | 2
jjj      | 33  | 3

The result that I need is:

nickname | age | true id of the row
jjj      | 33  | 3
j        | 11  | 1
jj       | 22  | 2

Can I do this with using IN() clause? This is the only idea that I came up with so if you have any idea/s that I may try then please tell me.

asked Jan 03 '17 at 10:10

Dumb Question

4

http://stackoverflow.com/questions/958627/mysql-order-by-values-within-in – Andrii Mishchenko Jan 03 '17 at 10:13
1

Possible duplicate of [Ordering by the order of values in a SQL IN() clause](http://stackoverflow.com/a/396771/5447994) – Thamilhan Jan 03 '17 at 10:13
thank you, that are greate answers, how can I close this and make this question officially duplicate? – Dumb Question Jan 03 '17 at 10:29

0 Answers0