Imagine a MySql tablet with multiple columns, one of which is called Name.

select * from TheTable WHERE Name='John Doe'

How to get the next row?

select *,LEAD(Name,1) AS 'next' from TheTable WHERE Name='John Doe'

There is also the keyword Over in the Lead function.
Quite lost as to how it all works and why it is so damn complicated.
It could be so easy.

Any help would be appreciated.

David