So, if a complete text index of a MySQL table contains a keyword that appears in 50% of data lines If that happens, then the keyword will be ignored by the match query
So if I have a table with the full text index 'content' that has 50 entries and 27 entries, the word 'computer' in the content field Include, and I Expertise have:
Select 'table' where the match ( `Samgri`) to ( 'Computer');
... The computer query will return zero results because the computer appears in more than 50% entries and therefore the keyword is ignored ...
There This functionality is a way of specifically disabling because it is problematic at the beginning of the age of the database
Use BOOLEAN 50 Full-text searches to bypass the% feature
Comments
Post a Comment