从MySQL中随机生成的数据加载更多功能

Question

I'm developing web service for my Android application. I have a lot of data in MySQL table. My service fetching this data randomly using RAND() function. I get a lot of records. So, I need to add load more functionality. But my data is constantly changing.

I've tried adding a limit but same data can come.

SELECT * FROM news ORDER BY RAND();

I want to come the data in sectional.

Can you give me an idea or method? Thanks.

Answer 1

One way to handle this would be by excluding the currently loaded items from the second query, for example:

SELECT * FROM news ORDER BY RAND() LIMIT 10;

Then, when making the second query you can exclude the items you've already loaded:

SELECT * FROM news WHERE `id` NOT IN(<loaded ids>) ORDER BY RAND() LIMIT 10;

This will ensure that there are no duplicates loaded.