SELECT column,(@rownum := @rownum + 1) as ROWNUM_ALIAS FROM table, (SELECT @rownum :=0) r ORDER BY column ;