CODEWITHSUNDEEP
sqlmysqlfull-text-search
Kristopher Ives
Kristopher Ives

Reputation: 6025

Does a FULLTEXT index speed up LIKE conditions?

We have a system that is migrating from an older VARCHAR using LIKE setup to one that uses FULLTEXT indexes. So far everyone is enjoying the switch, but we still have some code that isn't catered to the FULLTEXT queries.

Currently we have a column that is a VARCHAR(255) and we want to remove the 255 character limit. What will happen to areas that are using the LIKE queries?

Upvotes: 3

Views: 647

Answers (1)

Mark Byers
Mark Byers

Reputation: 837936

A fulltext index does not help to speed up queries using LIKE.

But an ordinary index can speed up LIKE conditions that start with a fixed string, for example LIKE 'FOO%'.

Upvotes: 7

Related Questions