Hello, I've been looking for a way to select and access all result rows starting at a specific offset. The according select clause with "LIMIT n,m" comes to mind, but unfortunately the current documentation is not very explicit concerning the appropriate value for m under these circumstances. What I'm looking for is a way to specify that for a query that would return x rows when not limited, I'd like to see X-n rows, starting at row n. All this without knowing X in advance :-)
Tests with mySQL 3.23.37 on Linux shows that "SELECT .... LIMIT n,-1" will achieve the desired result. Is this a supported approach, despite the fact it isn't documented, and may I expect this to work in future versions? Is there a different approach to this? And, last but not least, could the documentation be updated to reflect this issue? Thanks in advance. With regards, Jens -- email : [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php