select @ROWNUM:= @ROWNUM + 1 ROWNUM, RM.* from REQUEST_MST RM, (SELECT @ROWNUM:=0) TEST WHERE RM.`LANGUAGE` = 'cn'
OK, this will be enough for those who wanna study~
