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