SELECT SQL_CALC_FOUND_ROWS page_title
FROM web_pages LIMIT 1,10; SELECT FOUND_ROWS(); The second query (not that
COUNT() is never used) will tell you how many results there’re total, so you
can display a phrase "Found 13,450,600 results, displaying 1-10".
Note that FOUND_ROWS does not pay attention to the LIMITs you specified and
always returns the total number of rows affected by query.
No comments:
Post a Comment