记录的前五条和此记录的后五条记录,这个是怎么排序的?select * from table limit 0,5 where id not in(select id from table where ...这个是你前这个纪录的前面的) union select * from table where id not in(select id from table where ...这个是你前这个纪录的后面的)order by ...limit 0,5
1. 首先要有个排序的字段,否则,“前”“后”没有什么意义 2。(SELECT * FROM TABLE WHERE ID< 某值 LIMIT 5 UNION SELECT * FROM TABLE WHERE ID> 某值 LIMIT 5 ) ORDER BY ID
union
select * from table where id not in(select id from table where ...这个是你前这个纪录的后面的)order by ...limit 0,5
2。(SELECT * FROM TABLE WHERE ID< 某值 LIMIT 5
UNION
SELECT * FROM TABLE WHERE ID> 某值 LIMIT 5
) ORDER BY ID