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]

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!!

 

[sleipnir214]

warik:
Dude, pick one forum for your posts. Cross-posting, contrary to popular belief, does not get you better answers or answers more quickly.

All:
As this question is more apropos to the MySQL forum than the PHP forum, I am cross-posting my initial answer there.

Please direct your answers to thread436-665780


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. Anyway... thank's a lot.