开发者

MySQL FullText search without FULLTEXT index

开发者 https://www.devze.com 2023-01-20 04:42 出处:网络
Within one of our systems we have an option that switches the search system between a LIKE search, or a FullText search with either IN BOOLEAN MODE or WITH QUERY EXPANSION

Within one of our systems we have an option that switches the search system between a LIKE search, or a FullText search with either IN BOOLEAN MODE or WITH QUERY EXPANSION For some rea开发者_开发技巧son, the FULLTEXT index was missing but when the system was set to be IN BOOLEAN MODE the query still worked, in the case of WITH QUERY EXPANSION the query failed with:

1191 - Can't find FULLTEXT index matching the column list

I'm a little confused here as these are both FULLTEXT searches but one seems to work without the Index even existing!.

Am i missing something?

FYI this is using MySQL 5


Argh, just found the answer in the MySQL docs.

With regard to searches IN BOOLEAN MODE..

They can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow.

0

精彩评论

暂无评论...
验证码 换一张
取 消