For pagination we generally execute two query ,first for geting resultset by using limit in sql query and second to count the total no. of records . For total no. of records we again execute the same query with count(*).<\/p>\n
You would need two queries like these:<\/p>\n
[java]
\nSELECT COUNT(*) FROM author WHERE name LIKE ‘a%’;<\/p>\n
SELECT name, email FROM author WHERE name LIKE ‘a%’ LIMIT 10;
\n[\/java]<\/p>\n
But if you have a complex query that joins several tables and takes a while to execute \u2013 well, you probably wouldn\u2019t want to execute it twice and waste server resources.<\/p>\n
Since MYSQL 4.0 we can use SQL_CALC_FOUND_ROWS<\/strong> option in\u00a0 query which will tell MySQL to count total number of rows disregarding LIMIT clause<\/em><\/strong>. In main query add SQL_CALC_FOUND_ROWS<\/strong> option just after SELECT and in second query\u00a0 use FOUND_ROWS()<\/strong> function to get total number of rows without executing the query.<\/p>\n Queries would look like this:<\/p>\n [java] SELECT FOUND_ROWS(); Limitation:<\/strong> Must call second query immediately after the first one(or before next one) because SQL_CALC_FOUND_ROWS does not save number of rows anywhere.In the absence of the SQL_CALC_FOUND_ROWS option in the most recent successful SELECT statement, FOUND_ROWS() returns the number of rows in the result set returned by that statement. For pagination we generally execute two query ,first for geting resultset by using limit in sql query and second to count the total no. of records . For total no. of records we again execute the same query with count(*). You would need two queries like these: [java] SELECT COUNT(*) FROM author WHERE name LIKE […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":16},"categories":[1],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/5559"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=5559"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/5559\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=5559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=5559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=5559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nSELECT SQL_CALC_FOUND_ROWS name, email FROM author WHERE name LIKE ‘a%’ LIMIT 10;<\/p>\n
\n[\/java]<\/p>\n
\n<\/p>\n","protected":false},"excerpt":{"rendered":"