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