sql - how to disable mysql's match query's 50% exclusion -


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

"post-text" itemprop = "text">

Use BOOLEAN 50 Full-text searches to bypass the% feature


Comments