[請益] 讀取MySQL時自訂排序
我剛開始接觸 資料庫而已 ...請見諒
程式是這樣 我需要讀一某表 WHRER主鍵欄位名稱為 "ID"
排序要自訂排序 (1,2,5,40,32,6) 類似這樣
那我的寫法是這樣
"SELECT A欄 , B欄 FROM lists WHERE ID in (1,2,5,40,32,6)"
讀出這幾筆 結果是 1 2 5 6 32 40 的列陣
除了用PHP迴圈重排序外還有什麼 比較好的 MySQL 寫法嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.100.81.158
推
03/14 02:16, , 1F
03/14 02:16, 1F
推
03/14 02:23, , 2F
03/14 02:23, 2F
→
03/14 02:23, , 3F
03/14 02:23, 3F
→
03/14 02:36, , 4F
03/14 02:36, 4F
→
03/14 02:36, , 5F
03/14 02:36, 5F
推
03/14 12:21, , 6F
03/14 12:21, 6F
→
03/14 12:37, , 7F
03/14 12:37, 7F
→
03/14 12:37, , 8F
03/14 12:37, 8F
推
03/14 13:08, , 9F
03/14 13:08, 9F