MySQL fuzzy query, is there any more efficient than like?

Because we combine all the basic information of a piece of data into one field, and then use like to perform fuzzy search, the data volume increases a bit slowly. Is there a more efficient method than like? Is it feasible to add an index to this field? Newcomer

Reply content:

Because we combine all the basic information of a piece of data into one field, and then use like to perform fuzzy search, the data volume increases a bit slowly. Is there a more efficient method than like? Is it feasible to add an index to this field? Newcomer

Indexing can be improved, but if it is like '%xxxx%', then the efficiency is the same as without indexing
And what is the content you want to check?

Like 'xxxx%' will be faster

sphinx