List:General Discussion« Previous MessageNext Message »
From:Steve Lefevre Date:February 13 2006 4:59am
Subject:Re: arbitrary ORDER BY
View as plain text  
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

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