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: 124
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