MySQL Sorting Problem

[warik]

Dear all,

What SELECT is the best for this sorting problem?

table mytable:

No | Name | ID
1 | aaa | 20
2 | bbb | 90
3 | ccc | 80
4 | ddd | 10



I would like to sort become like this :
Sort from name, but ID 90 will be the last. So it will be like this:

No | Name | ID
1 | aaa | 20
3 | ccc | 80
4 | ddd | 10
2 | bbb | 90


What I know to sort name with:
select * from mytable order by name.....
what next? or any other advice?

Thank you in advance.

 

[sleipnir214]

Please don't cross-post.

Given that data, there is no sort order that can produce the exact output you have specified.

If you use "order by ID", you'll get:

4 | ddd | 10
1 | aaa | 20
3 | ccc | 80
2 | bbb | 90


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[warik]

Thank you sleipnir214 for your answer. I thought this problem also can be solved with php script except MySQL itselft. So I wrote at PHP Forum and MySQL Forum.
Anyway... thank's a lot.

 

[swampBoogie]

order by case id when 90 then 1 else 0 end,name