MySQL排序特定值置后其他值正序

如下所示：

select * from FD_DictionaryItem where DictionaryID=72 order by DictionaryItemID=-1 ASC,DictionaryItemID;

 

转载地址：

https://blog.csdn.net/imphp/article/details/25302677