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
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