SELECT @rownum:=@rownum + 1 AS RNUM , a.* FROM some_table AS a, (SELECT @rownum:=0) AS R WHERE a.some_column = 1 ORDER BY 1;