Good to know! Although, like you said, that thread dates back to MySQL 5.0 - I wouldn't hedge my bets on it today... Is there a "best practices" way to handle

Good to know! Although, like you said, that thread dates back to MySQL 5.0 - I wouldn't hedge my bets on it today... Is there a "best practices" way to handle pagination of complex queries without running the query twice?