Need Query Help.. Urgent....

[write2ashokkumar]

hi..

i have query like this..

select id,name from tbl where id in(5,2,4,1,3);

When i execute the above query.. i get the result set with ascending order by id
by default. But i need the output without order by.
i need the order by valuewhatever in the IN condition.

Expecting Output:

id ---- Name
----------------
5------- xxx
2------- yyy
4------- zzz
1------ aaa
3----- bbbb


Can u any one solve this problem?

Thanks & Regards,
S.Ashokkumar.

[ronverdonk]

hi..

i have query like this..

select id,name from tbl where id in(5,2,4,1,3);

When i execute the above query.. i get the result set with ascending order by id
by default. But i need the output without order by.
i need the order by valuewhatever in the IN condition.

Expecting Output:

id ---- Name
----------------
5------- xxx
2------- yyy
4------- zzz
1------ aaa
3----- bbbb

Can u any one solve this problem?

Thanks & Regards,
S.Ashokkumar.

You cannot get it without using the ORDER BY clause. The following will give it to you in the defined order

SELECT id,name FROM tbl 
   WHERE id IN(5,2,4,1,3) 
   ORDER BY FIELD(id,5,2,4,1,3);

Ronald :cool: