MySQL Forums
Forum List  »  Newbie

Can you have a "self-defined" ORDER BY
Posted by: Wim Roffel
Date: May 27, 2018 03:10PM


I would like to get my results from a query in a specific non-alphabetical order.

Suppose I have a list of addresses. I can get them ordered by city with
"ORDER BY city"

But now I want them to come in a non-alphabetical order (but still ordered by city), say "Amsterdam, Washington, New York".

Is it possible to make a query that gives that result?

Options: ReplyQuote

Written By
Can you have a "self-defined" ORDER BY
May 27, 2018 03:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.