今天遇到需要把部分结果置顶的需求,也就是查出N个记录后,其中2条无论怎么变都要放在最上面,就像论坛帖子置顶一样
例子如下:
SELECT `AritcleID` FROM `article` LIMIT 0 ,20;
排序
SELECT `AritcleID` FROM `article` LIMIT 0 ,20 ORDER BY `AddTime` DESC;
结果就是 20,19,18,17,16.........3,2,1
现在把AritcleID为10和ID为7 的前置,变成 10,7,20,19,18,17,16......3,2,1,注意 10和7的顺序是先有10 后面是 7
SELECT `AritcleID` FROM `article` LIMIT 0 ,20 ORDER BY `AritcleID`=10 DESC,`AritcleID`=7 DESC, `AddTime` DESC;
这样,10和7就按照指定顺序置顶了。如果只是置顶一组数据,而无需关心谁前谁后,in进去就行,如下:
SELECT `AritcleID` FROM `article` LIMIT 0 ,20 ORDER BY `AritcleID` in(10,7)DESC, `AddTime` DESC;