[請益] MySQL SELECT 大量不規則條件
假設 table 裡有 1000 萬筆資料,每筆資料都有 uniqid,
uniqid 皆為不規則,例如:
uniqid data
-------- --------
abcdefgh data_1
acegbdfh data_2
adgbehcf data_3
aebfcgdh data_4
…
afbgchde data_1000萬
現在手邊有 100 個 uniqid,需要從該 table 取出資料,
請問 SQL 該怎麼下最妥當呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 125.227.26.181
※ 文章網址: https://www.ptt.cc/bbs/PHP/M.1439204239.A.741.html
→
08/10 19:04, , 1F
08/10 19:04, 1F
→
08/10 19:30, , 2F
08/10 19:30, 2F
→
08/10 19:30, , 3F
08/10 19:30, 3F
※ 編輯: nakahusa (125.227.26.181), 08/10/2015 19:31:53
→
08/10 22:41, , 4F
08/10 22:41, 4F
→
08/11 00:15, , 5F
08/11 00:15, 5F
→
08/11 10:25, , 6F
08/11 10:25, 6F
→
08/11 10:32, , 7F
08/11 10:32, 7F
推
08/11 11:24, , 8F
08/11 11:24, 8F
→
08/11 11:28, , 9F
08/11 11:28, 9F
→
08/11 13:33, , 10F
08/11 13:33, 10F
→
08/11 13:33, , 11F
08/11 13:33, 11F
→
08/11 16:07, , 12F
08/11 16:07, 12F
→
08/11 16:08, , 13F
08/11 16:08, 13F
→
08/11 17:09, , 14F
08/11 17:09, 14F
→
08/11 17:40, , 15F
08/11 17:40, 15F
→
08/12 10:18, , 16F
08/12 10:18, 16F
→
08/12 10:20, , 17F
08/12 10:20, 17F
推
08/12 11:58, , 18F
08/12 11:58, 18F
→
08/12 14:48, , 19F
08/12 14:48, 19F
推
08/14 17:02, , 20F
08/14 17:02, 20F