Thursday, March 25, 2010

how to get row number in mysql select query

Contact Us :
Hire PHP Web Developer

Example Table : test

id  name
====   ======
2 xyz
5       abc
6       pqr
7       uvw


Query :
SET @i := 0;
SELECT @i := @i + 1 as row_num,id,name FROM test WHERE 1=1


OUTPUT
row_num  id  name
=======  ====   ======
1        2 xyz
2        5       abc
3        6       pqr
4        7       uvw