Toggle nav
Posted 4 years ago - updated 4 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();