List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:February 13 2006 8:34am
Subject: Re: arbitrary ORDER BY
View as plain text  
In article <43F0123A.2080701@stripped>,
Steve Lefevre <lefevre.10@stripped> writes:

> For posterity, this is how I solved the problem:

> To create an abitrary for the ORDER BY clause, create a field like this:

> SELECT

> FIELD( field,
>   "arbitrary sort string 2",
>   "arbitrary sort string 3",
>   "arbitrary sort string 1"
> ) as sort_order

> FROM table
> ORDER BY sort_order

It's not necessary to SELECT something in order to ORDER BY it.  Just do

SELECT anything_else
FROM TABLE
ORDER BY FIELD(field,
  "arbitrary sort string 2",
  "arbitrary sort string 3",
  "arbitrary sort string 1"
)

Thread
arbitrary ORDER BYSteve Lefevre12 Feb
  • Re: arbitrary ORDER BYPeter Brawley12 Feb
  • Re: arbitrary ORDER BYHarald Fuchs13 Feb
Re: arbitrary ORDER BYSteve Lefevre13 Feb