Use LIMIT to paginate results in MySQL query
This cannot be done.
See solution here: MySQL Math and COUNT(*) in LIMIT
I would recommend using javascript or something to handle the first parameter (i.e. offset) such as:
limit 0,20
on first page and limit 21,20
on second...
For example if your first page has a get variable in the url www.example.com?page=1
offset = (page - 1)*20 ;
row_count = 20;
select * from table limit (offset, row_count);
Define Offset for the query using the following syntax
SELECT column FROM table
LIMIT {someLimit} OFFSET {someOffset};
For example, to get page #1 (records 1-10), set the offset to 0 and the limit to 10;
SELECT column FROM table
LIMIT 10 OFFSET 0;
To get page #2 (records 11-20), set the offset to 10 where the limit to 10
SELECT column FROM table
LIMIT 10 OFFSET 10;
MySQL requires numeric constants for that LIMIT syntax.
From http://dev.mysql.com/doc/refman/5.7/en/select.html:
The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions:
Within prepared statements, LIMIT parameters can be specified using ? placeholder markers.
Within stored programs, LIMIT parameters can be specified using integer-valued routine parameters or local variables.
Compute the constant on the Java side.