Re: arbitrary ORDER BY

2006-02-13 Thread Harald Fuchs
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", > "arb

Re: arbitrary ORDER BY

2006-02-12 Thread 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 sor

Re: arbitrary ORDER BY

2006-02-12 Thread Peter Brawley
her type", type = "yes another arbitrary type" ... However, my arbitrary ORDER BY statements don't seem to be working on MySQL 5.0.16. Am I remembering correctly? I can't seem to find anything in the MySQL manual. Steve -- No virus found in this outgoing message

arbitrary ORDER BY

2006-02-11 Thread Steve Lefevre
ot; ... However, my arbitrary ORDER BY statements don't seem to be working on MySQL 5.0.16. Am I remembering correctly? I can't seem to find anything in the MySQL manual. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]