Re: arbitrary ORDER BY

[Steve Lefevre]

Peter Brawley wrote:
> Steve,
> 
> Look for 'FIELD(' at 
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html.
> 
> PB
> 

Thanks, Pete!

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