Does the FULLTEXT Index Accelerate LIKE?

Question

We have a system that migrates from an older one VARCHARusing one LIKEto one that uses indexes FULLTEXT. So far, everyone is enjoying the switch, but we still have code that does not satisfy the request FULLTEXT.

We currently have a column VARCHAR(255), and we want to remove the 255 character limit. What will happen to areas that use queries LIKE?

Answer 1

The full-text index does not help speed up query execution with LIKE.

LIKE, , LIKE 'FOO%'.