Re: Retrieving Next Row in Index

[Rick James]

Let's say you want the next one after name='abc':

SELECT ... FROM ...
WHERE name > 'abc'
ORDER BY name
LIMIT 1;

That works well for a non-compound, UNIQUE index.
For a compound index (eg, INDEX(last_name, first_name)), it is more complex.
For non-UNIQUE, the problem is non-deterministic, so clarify what you want.

Or you could use the "Handler" interface.