从主id中获取大于或小于的记录 - Fetch record greater than and less than from primary id

Fetch record greater than and less than from primary id

我有铅表，其中lead_id是主id，我想在单个查询中获取下一个lead_id和上一个lead_id。Lead_id是自动递增的，但Lead_id与用户有关系。是否有可能在单个查询中获取数据?

也许你可以尝试类似的东西

(select lead_id from lead where lead_id < 4 order by lead_id DESC limit 1)    
union 
(select lead_id from lead where lead_id > 4 order by lead_id ASC limit 1)

试试这个

select * from lead where 
      lead_id = (select min(lead_id) from lead where lead_id > 4) AND 
      lead_id = (select max(lead_id) from lead where lead_id < 4)

还没有测试过这个代码，但应该像下面的$lead_id是你的php lead_id与一个表命名为lead

$query="SELECT * FROM lead WHERE lead_id =($lead_id+1) OR lead_id=($lead_id -1)";