Skip First Record From MySQL Result

Question

In MySQL, I have data with the same id in the table. For example, I have 3 data with the id X now whenever I query

SELECT * FROM table WHERE id = X ORDER BY id

It will return me all 3 data having an id X Now I am looking for a solution to skip the first row from data which comes in the result.

I looked up in this answer and also LIMIT & OFFSET, but I did not get any proper solution. How can I skip the first row?

What was wrong with the things you tried with OFFSET? And why do you want to skip randomly one of the rows? — Sami Kuhmonen, Jul 27 '18 at 05:41
Besides using `OFFSET`, you could just read in some number of records and then skip the first row in your PHP script. — Tim Biegeleisen, Jul 27 '18 at 05:42

Sinto · Accepted Answer · 2018-07-27T05:43:20.063

2

Can you check this out:

SELECT * FROM table WHERE id = X ORDER BY id LIMIT 10 OFFSET 1;

In my Fiddle, there is 3 records with similar id(1). After executing query, output showing 2 records by skipping first record(from a total of 3)

edited Jul 27 '18 at 05:43

answered Jul 27 '18 at 05:40

Sinto

Can you do a fiddle to check. – Sinto Jul 27 '18 at 05:43
Please correct this to : SELECT * FROM table WHERE id = X ORDER BY id ASC LIMIT 10 OFFSET 1; – Senior PHP Developer Jul 27 '18 at 06:15

1 Answers1