mysql order question

Dan Buettner · *nix forums Guru Wannabe Joined: 13 Oct 2005 Posts: 119

Not sure there's a good way to do that ... here's one possible solution:

create a little extra table like so:

create table mytemptable
(mytemptable_id int not null auto_increment primary key,
table_id int,
key table_id_idx (table_id));

then insert your values for your IN clause into 'mytemptable' in the
proper order,
then issue a query that joins on that table and orders by the ID
number of the temp table:

select t.*
from table t, mytemptable mtt
where t.id = mtt.table_id
order by mtt.mytemptable_id

And finally delete your entries from your extra table so the next
query is accurate.

Not pretty eh?

Dan

On 7/19/06, OKAN ARI <liste@ari-tech.com> wrote:

OKAN ARI · *nix forums beginner Joined: 16 Sep 2005 Posts: 8

I have a sql query like SELECT * FROM table WHERE id IN (4,88,23);
Result order in ID is: 4,23,88

But I need to receive result in order 4,88,23. So how can I manage to receive result in order LIKE IN() clause?

regards, okan

Google