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

如下所示:

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

转载地址:

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

原文地址:https://www.cnblogs.com/xuweiqiang/p/14255521.html