How to select rows above #

Question

I'm currently trying to setup a query that only selects from a row number and upwards from it. I've tried to use the LIMIT method in this way:

SELECT name FROM names LIMIT 1500, *

Which I expected to select from row number 1500 till the table's rows ended, but got a MySQL error instead.

I then tried to use a conditional for the ID of the rows like so:

SELECT name FROM names WHERE id >= 1500

Which gave unpredictable behavior since there are rows that get deleted, so it's not taking the real row numbers.

Possible duplicate of [Mysql Offset Infinite rows](https://stackoverflow.com/questions/255517/mysql-offset-infinite-rows) — Ivar, Jun 04 '17 at 12:21

score 2 · Accepted Answer · answered Jun 04 '17 at 12:10

2

I think offset will do what you want. Unfortunately, MySQL requires a LIMIT value, but you can just put in a ridiculous number:

SELECT name
FROM names 
OFFSET 1499
LIMIT 999999999;

answered Jun 04 '17 at 12:10

Gordon Linoff

Although a bit messy, it works perfectly. Thanks for the quick solution. :D – Jack Hales Jun 04 '17 at 12:16

ScaisEdge · Answer 2 · 2017-06-04T12:27:29.137

1

you could use a subquery

select name 
from names 
where id > (
    select max(id) 
    from names 
    order by names  
    limit 1500 
)

edited Jun 04 '17 at 12:27

answered Jun 04 '17 at 12:08

ScaisEdge

2 Answers2