Full text indexing why check out data is not the same

Because I want to according to the two field to fuzzy search by ordinary or words will be very slow, such as:
SELECT * FROM Nc_ContentInfo
where Nci_Title like '%600273%' or Nci_Content like '%600273%'
The SQL statement in 9 seconds, detect 38 data

Then I built a full-text index, such as:
select * from Nc_ContentInfo
where contains((Nci_Title,Nci_Content),'"*600273*"')
But check this out. The data is only 33, which is why?

Started by Lori at November 21, 2016 - 7:46 AM

Full text indexing in the pursuit of speed, to reduce the degree of accuracy of search.
Speed and accuracy can't be together.

Posted by Hubery at November 25, 2016 - 8:21 AM

try this,
select * 
 from Nc_ContentInfo
 where contains((Nci_Title,Nci_Content),'"600273*"') 

Posted by Burnell at December 01, 2016 - 8:34 AM

Query contains is not accurate.
Reference resources

Another: the fulltext catalog need to refresh, to ensure that the query results are accurate.

Posted by Burnell at December 10, 2016 - 9:25 AM

Use this to try.:


select * from 
Nc_ContentInfo
where FREETEXT((Nci_Title,Nci_Content),'haha') 

Posted by Cornelius at December 14, 2016 - 9:35 AM