Re: mysql order question

2006-07-19 Thread Dan Buettner
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 'mytemptabl

mysql order question

2006-07-19 Thread OKAN ARI
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