I guess I've never noticed that but why not just select more than one calculation such
as:
SELECT sqrt(col) AS blarg, sqrt(col) + 1 AS order_blarg
FROM table
ORDER BY order_blarg
its a work around but it should work fine
-John
--
MySQL General Mailing List
For list archives: http://lists.mys
All tested in MySQL 4.0.x and 4.1.x (MyISAM and InnoDB):
(1) A query with an expression in an ORDER BY clause works well:
SELECT *
FROM `table1`
ORDER BY `col` + 1
(2) A query with an alias of a calculated field in the ORDER BY works also:
SELECT * , sqrt( `col1` ) AS blarg
FROM `table1`