如何获取MySQL中的下一个/上一个记录? [英] How to get next/previous record in MySQL?

问题描述

说我有ID为3、4、7、9的记录，并且我希望能够通过下一个/上一个链接进行导航，从而从一个记录转到另一个记录.问题是，我不知道如何获取具有最近的较高ID的记录.

Say I have records with IDs 3,4,7,9 and I want to be able to go from one to another by navigation via next/previous links. The problem is, that I don't know how to fetch record with nearest higher ID.

因此，当我有一个ID为4的记录时，我需要能够获取下一个现有记录，即7.查询可能类似于

So when I have a record with ID 4, I need to be able to fetch next existing record, which would be 7. The query would probably look something like

SELECT * FROM foo WHERE id = 4 OFFSET 1

如何获取下一个/上一个记录而不获取整个结果集并手动迭代?

我正在使用MySQL 5.

I'm using MySQL 5.

推荐答案

下一个:

select * from foo where id = (select min(id) from foo where id > 4)

上一个:

select * from foo where id = (select max(id) from foo where id < 4)

这篇关于如何获取MySQL中的下一个/上一个记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！