mysql - Best way to implement paging in queries -

i know best way implement paging in queries.

currently, doing this:

select   columns   (select columns table order column)   rownum between start , end

is best way go it?

yes, that's best way know far. if working sql server, may combine row_number , cte together. take @ http://www.sqlteam.com/article/server-side-paging-using-sql-server-2005

and mysql

select myfield sometable limit [offset], [pagesize]

of course should replace [offset] , pagesize appropriate values.

shell