MySQL 下不規則排序 |
發布時間: 2012/8/22 17:20:48 |
SQL查詢語句如下: select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) 讓結果按10,32,22,76,13,44的順序檢索出來,請問如何書寫? (sql能力) select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) order by field(ID,10,32,22,76,13,44) 本文出自:億恩科技【www.endtimedelusion.com】 |