0
I am creating a paging system and in mysql I am using this way
I take from record 1 and walk up to the 20
SELECT * FROM sistema LIMIT 1 , 20
I pick up from record 2 and walk up to 21
SELECT * FROM sistema LIMIT 2 , 21
and so on but I want you to have one more LIMIT for example if you have 500 record to do this way
SELECT * FROM system LIMIT 300
more in the same query I want to paginate within this 300 record something like
SELECT * FROM sistema LIMIT 1 , 20 , 300