MYSQL get all results but first

Question

Possible Duplicate:
Mysql Offset Infinite rows

I am trying to get all results for a query BUT NOT the first one, I have the following but its giving me an error, please help; thanks.

SELECT DISTINCT `memberID` FROM `discusComments` 
WHERE `topicID` = 4 ORDER BY `id` DESC OFFSET 1

See http://stackoverflow.com/questions/255517/mysql-offset-infinite-rows. Can't use `OFFSET` without `LIMIT`. — Rob, Aug 17 '11 at 19:19

score 14 · Accepted Answer · answered Aug 17 '11 at 19:20

14

SELECT DISTINCT `memberID` 
FROM `discusComments` 
WHERE `topicID` = 4 
ORDER BY `id` 
DESC limit 1,x

where x is a number enough great to contain all your records.

or use, instead of x, 18446744073709551615, that is maximum value of bigint unsigned.

answered Aug 17 '11 at 19:20

Nicola Cossu

score 3 · Answer 2 · answered Aug 17 '11 at 19:26

3

Ignore the first row when you receive the results in your application. It is much neater than using an ugly query like:

SELECT * FROM my_table LIMIT 1, 18446744073709551615

Getting one extra row will not really hurt your performance.

answered Aug 17 '11 at 19:26

nobody

I would not agree it is best to just return the first row when question has asked to remove it... it is as neat as methods to remove the first row. Also there are many cases where teh row data might be large enough to not want to transport it from teh server to the application, e.g. data stored in a BLOB – Barry Apr 03 '16 at 12:08

2 Answers2