SQL 200 Row Limit – How to Implement Pagination or Infinite Scroll?

Hi everyone,

I’m currently developing a search-based website using MySQL as the database server. However, I’ve encountered a limitation where SQL queries return a maximum of 200 rows when fetched through the connector.

The issue is that my search results often exceed this 200-row limit, and I need a way to display more results—either through pagination or infinite scrolling.

I’ve been stuck on this problem for two days now and haven’t been able to make progress. Could anyone guide me on how to properly implement pagination or infinite scroll to fetch and display additional results beyond the 200-row limit?

Your help would be greatly appreciated!

Thank you!