custom paging query in mysql

SELECT * FROM (SELECT @rownum:=@rownum+1 ‘rank’, p.* FROM tblcity p, (SELECT @rownum:=0) r WHERE isactive =TRUE ORDER BY cityname ASC ) t WHERE rank>0 AND rank<50

Like this:

Be the first to like this post.

This entry was posted on June 23, 2010 at 10:38 am and is filed under Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.