Toggle nav
Posted 8 years ago - updated 8 years ago mysql
Add SQL_CALC_FOUND_ROWS to your query:
SQL_CALC_FOUND_ROWS
SELECT SQL_CALC_FOUND_ROWS title,author FROM books WHERE title LIKE '%%harry%%' LIMIT 10;
Then immediately after this query run:
SELECT FOUND_ROWS();