从数据库中反复获取5条记录

Question

I am developing an android app where i want to fetch 5 records each time using this query.

SELECT *from contest_table WHERE created_by='$me' LIMIT 5;

Now i get 5 records , but i want to fetch more 5 (next) records from data base when i click on "FETCH-MORE-RECORD" button inside the app

Answer 1

You can use OFFSET :

SELECT * from contest_table WHERE created_by='$me' LIMIT 5,5; 

This will return 5 more rows, from position the 6th row (6-10).

The first number is to declare the start position of the fetch, and the second one is two declare how many to fetch.

This could also be written like this:

SELECT * from contest_table WHERE created_by='$me' LIMIT 5 OFFSET 5;