MySQL – get next and previous of a record by date

I have table like

SELECT id, name, date FROM `table` ORDER BY `date` DESC, id DESC
10  |a|2020-01-08 20:40:00
9   |b|2020-01-08 20:40:00
8   |c|2020-01-08 20:40:00
500 |d|2020-01-06 22:49:00
7   |e|2020-01-06 22:00:00

How to get next and previous of a record. (ex: i have info of a record with id = 8 then how to get a next record is 9 and a previous record is 500)

Leave a Reply

Your email address will not be published. Required fields are marked *