TA貢獻(xiàn)1951條經(jīng)驗(yàn) 獲得超3個(gè)贊
這很有趣，但問(wèn)題也可以通過(guò)準(zhǔn)備好的陳述來(lái)解決(不確定是否適合每個(gè)人)，例如：
mysql> EXPLAIN SELECT * FROM words WHERE word IN (SELECT word FROM phrase_words);
+----+--------------------+--------------+...
| id | select_type | table |...
+----+--------------------+--------------+...
| 1 | PRIMARY | words |...
| 2 | DEPENDENT SUBQUERY | phrase_words |...
+----+--------------------+--------------+...
mysql> EXPLAIN SELECT * FROM words WHERE word IN ('twist','rollers');
+----+-------------+-------+...
| id | select_type | table |...
+----+-------------+-------+...
| 1 | SIMPLE | words |...
+----+-------------+-------+...
所以，只需在存儲(chǔ)過(guò)程中準(zhǔn)備語(yǔ)句，然后執(zhí)行它。以下是一個(gè)想法：
SET @words = (SELECT GROUP_CONCAT(word SEPARATOR '\',\'') FROM phrase_words);
SET @words = CONCAT("'", @words, "'");
SET @query = CONCAT("SELECT * FROM words WHERE word IN (", @words, ");";
PREPARE q FROM @query;
EXECUTE q;
舉報(bào)