next row from mysql using sql Query

Question

My current query is

SELECT p.* FROM proxies p where p.last_used=1

here in db, according the query select id=4 but i want to select next record wheer id=5 (For details please click on image) next row from mysql using sql Query

need help

"next record" is subjective, it depends on the ordering of the data. The order it appears when just browsing through phpmyadmin is not something to rely on - database engines don't store data in any particular order (or at least, that ordering is not guaranteed). What exactly is the criteria that makes id 5 the "next" row? e.g. is the formula to look at the id of the "last used" row and increment id by 1? Or just get the next highest id? Or something else? what if a row is deleted in the meantime? — ADyson
– ADyson, Commented Jan 5, 2017 at 15:31
Take a look at stackoverflow.com/questions/1446821/… , it might be helpful. — Alvaro Flaño Larrondo
– Alvaro Flaño Larrondo, Commented Jan 5, 2017 at 15:32

Bernd Buffen · Accepted Answer · 2017-01-05 15:37:14Z

2

You can use a query like this:

SELECT p.id FROM proxies p where p.id >
(SELECT p.id FROM proxies p where p.last_used=1 LIMIT 1)
ORDER BY p.id 
LIMIT 1;

edited Jan 5, 2017 at 15:37

answered Jan 5, 2017 at 15:32

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Strawberry Over a year ago

In the absence of an ORDER BY clause, LIMIT is fairly meaningless.

Bernd Buffen Over a year ago

@Strawberry - you are right - i will add it in my answer (sorry)

Strawberry Over a year ago

There's still a LIMIT there without an ORDER BY !!

Collectives™ on Stack Overflow

next row from mysql using sql Query

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related