使用前:
SELECT `goods_id` FROM `sdb_goods` LIMIT 0 , 30
<a target="_blank" href="http://blog.51cto.com/attachment/201208/171130287.jpg"></a>
使用后
SELECT `goods_id` FROM `sdb_goods` ORDER BY `goods_id` = 4 DESC LIMIT 0 , 30
<a target="_blank" href="http://blog.51cto.com/attachment/201208/171215442.jpg"></a>
再来完善下,
SELECT `goods_id` FROM `sdb_goods` ORDER BY `goods_id` = 4 DESC, `goods_id` ASC LIMIT 0 , 30
<a target="_blank" href="http://blog.51cto.com/attachment/201208/171249907.jpg"></a>
ok!
自己学以致用:
需求:需要将招聘“研发类(parentid=1)”的职位永远置顶并按发布时间排序。后面分类的职位直接按发布时间排序即可。
<a target="_blank" href="http://blog.51cto.com/attachment/201208/172928491.jpg"></a>
使用后:
SELECT * FROM job ORDER BY parentid=1 DESC,TIME desc
<a target="_blank" href="http://blog.51cto.com/attachment/201208/172957634.jpg"></a>
很奇妙,不错,省了很多代码。
本文转自许琴 51CTO博客,原文链接:http://blog.51cto.com/xuqin/976601,如需转载请自行联系原作者