In article <[EMAIL PROTECTED]>, Steve Lefevre <[EMAIL PROTECTED]> 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" ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]