MySQL - Fulltext Index Search Issue

Question

Two rows in the my database have the following data:

brand       | product                     | style
=================================================
Doc Martens | Doc Martens 1460 Boots      | NULL
NewBalance  | New Balance WR1062 SG Width | NULL

Mininum word length is set to 3, and a FULLTEXT index is created across all the three columns above.

When I run a search for IS BOOLEAN matches for +doc in the index, I get the first row returned as a result. When I search for +new, I get no results.

Can someone explain why?

Thanks.

zerkms · Accepted Answer · 2010-04-04 07:42:02Z

3

It called FULLTEXT because of it indexes whole words. so for searching words started with "New" you have to put "astrisk" sign in the end:

MATCH (`brand`) AGAINST ('new*')

More detailed here

answered Apr 4, 2010 at 7:42

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL - Fulltext Index Search Issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related