Assuming the values in the column are unique, this will tell you the the numerical position of a given row based on the column.

  SELECT COUNT($col)
    FROM $table
   WHERE $col <= $this_row_col_value
[download]

Or perhaps I misunderstand what you mean by "rank", if so, please explain.