MySQL 查询文章的上下篇

如图，如果查询ID39的上一条信息和下一条信息

 

解决方案：

SELECT w_id, w_web_name FROM w_web WHERE w_id<39 ORDER BY w_id DESC LIMIT 0, 1;

SELECT w_id, w_web_name FROM w_web WHERE w_id>39 ORDER BY w_id ASC LIMIT 0, 1;

 

效果图：