The full-text index only at the beginning of search and content will be the result when the same tex-CodePudding

Such as the database is "fifteen thousand yuan", if the user search "five thousand" there is no results, only search "ten thousand" or "fifteen thousand" is the result, could you tell me what to do can let users search "five thousand" also can search?

CodePudding user response:

Use % matches? Front plus %, similar like '% fifty thousand percent'

CodePudding user response:

The

reference 1/f, CKC response:

% matches? Front plus %, similar like '% fifty thousand percent' such

This won't be able to search

CodePudding user response:

Fuzzy matching, true not line, in SQL using regular can

CodePudding user response:

WHERE COL % fifty thousand percent

CodePudding user response:

reference 4 floor lzd_83 response:

WHERE COL % fifty thousand percent

SELECT * FROM zy WHERE the match against (name) (' % % talent IN BOOLEAN MODE)
Is this use? Search less than

CodePudding user response:

Database "America's got talent", if search "us" or "the United States of" the same as data in the database from the beginning of keywords will have the result

CodePudding user response:

reference 5 floor luxooq reply:

Quote: refer to 4th floor lzd_83 response:

WHERE COL % fifty thousand percent

SELECT * FROM zy WHERE the match against (name) (' % % talent IN BOOLEAN MODE)
Is this use? Search less than

Full-text index is not need to add % number, it is said that don't need to start from scratch

CodePudding user response:

refer to 7th floor CKC response:

Quote: refer to fifth floor luxooq response:

Quote: refer to 4th floor lzd_83 response:

WHERE COL % fifty thousand percent

SELECT * FROM zy WHERE the match against (name) (' % % talent IN BOOLEAN MODE)
Is this use? Search less than

Full-text index is not need to add % number, it is said that don't need to start from scratch

Yes, in most cases it without %
But I use a full-text index can only search results from the very beginning, as if must use,
Can any other efficient search method of fuzzy matching?