MYSQL Match AGAINST

Question

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?

Thank you very much.

Answer 1

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);