select (@rowNO := @rowNo+1) AS rowno,field1,field2,field3 from

(select field1,field2,field3 from table_name where field3 = '2012-04-21') a,

(select @rowNO :=0) b