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"
)
