Getting total records when using limit in mysql

Posted 4 years ago - updated 4 years ago mysql

Add SQL_CALC_FOUND_ROWS to your query:

SELECT SQL_CALC_FOUND_ROWS title,author FROM books WHERE title LIKE '%%harry%%' LIMIT 10;

Then immediately after this query run:

SELECT FOUND_ROWS();