mysql查找結果中自動加序號列

mysql查找結果中自動加序號列   查找mysql 數據庫 自動 添加 序號 字段列1,2,3,4..........   就像這樣。。    

[sql] 
select (@rowNO := @rowNo+1) AS rowno,zhuanfaContent,content,sendDate,sendTime,zhuanfaAuthor,zhuanfaLink from (SELECT zhuanfaContent,content,sendDate,sendTime,zhuanfaAuthor,zhuanfaLink  FROM t_toefldata_zhuanfa  where sendDate = '2012-04-21') a,(select @rowNO :=0) b  

“t_toefldata_zhuanfa”