Order by
Posted: Wed Feb 09, 2011 7:15 am
Code: Select all
Select * from tbl where id in (2,4,3,6,9,35);For the above query i am getting answers in sorted.
How to get without sorting.?
Right now i am getting ,
2
3
4
But i want
2
4
3
6
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
Select * from tbl where id in (2,4,3,6,9,35);Code: Select all
Select * from tbl where id in (2,4,3,6,9,35) order by field(id, 2,4,3,6,9,35);