The following might help, but will certainly be quite slow:
SELECT ... ORDER BY ABS(SUBSTRING(field, 4));
A better (and faster) solution will probably be indexing the records with a numeric field, as usual.
Fred,
Doesn't MySQL always physically sort the rows and not use the index to obtain row order? Do you (or anyone else listening) know of a way to get MySQL to use the index for sorting instead of physically sorting the rows? TIA
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]