MYSQL匹配反对 [英] MYSQL Match AGAINST

问题描述

到目前为止，我有一张名为'business'的表，其中包含13,000,000条记录。
我想在lowerTitle和phone字段中搜索此表。
如果我正在使用：

I have table called 'business' with 13,000,000 records so far. I want to search in this table on lowerTitle and phone fields. If I'm using:

SELECT * FROM business WHERE MATCH (lowerTitle) AGAINST (`blabla` IN BOOLEAN MODE);

它工作正常，现在我想搜索手机字段使用：

It's working fast, Now I want to search also in phone field using:

SELECT * FROM business WHERE MATCH (lowerTitle,phone) AGAINST (`blabla` IN BOOLEAN MODE);

出于某种原因，它工作得非常慢，有人可以在这里提供帮助吗？

for some reason, it's working very slow, someone can assist here?

非常感谢。

推荐答案

确保您有全文（不是btree）索引（lowerTitle，phone）。如果不是：

Make sure you've a full text (not btree) index on (lowerTitle,phone). If not:

create fulltext index business_ft_idx on business(lowerTitle, phone);

这篇关于MYSQL匹配反对的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！