MYSQL - sort a list, how to always have one result at the end?

Posted by GSto on Stack Overflow See other posts from Stack Overflow or by GSto
Published on 2010-06-16T14:56:28Z Indexed on 2010/06/16 15:02 UTC
Read the original article Hit count: 125

Filed under:
|

I have a table with just as ID and a value. Let's say this list have 4 items, such as Apple,Banana, Zuchinni, and Other. I want to sort the list alphabetically, but always have 'Other' be the last option. Is there a way to accomplish this using a query?

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql