mysql like 全文索引,MySQL全文搜索vs Like %%

20

Full-text search is the kind of search based on special sort of index (full-text, obviously). So you get the power of O(lgN) while searching using it.

全文搜索是一種基於特殊索引的搜索(顯然是全文)。因此，在使用它時，您可以獲得O(lgN)的強大功能。

While like %% always causes table fullscan which can be terrible slow (when you have 100k and more rows).

雖然像%%總是導致表fullscan可能很慢(當你有100k和更多行)。

Personally I use Like %% when it is a small table (0-1000 rows) and I'm sure that it will never grow (and, important, when like %% fits the task requirements).

我個人使用Like %%，當它是一個小表(0-1000行)時，我確信它永遠不會增長(而且，重要的是，當%%符合任務要求時)。

Note: fulltext indexes are available only for myisam SE. If you use innodb - then you need to look at some 3rd party indexing software like sphinx

注意：全文索引僅適用於myisam SE。如果您使用innodb - 那么您需要查看一些第三方索引軟件，如sphinx