Is there any way to test this? I doubt it is 50%, some of these words only appear once or twice within the content.
Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * Accept online Credit Card payments www.commerceengine.com.au * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -----Original Message----- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 June 2006 10:24 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Full-Text problems Perhaps the searches that return "nothing" are actually matching more than 50% of the record in the table. >From the manual: "In addition, words that are present in more than 50% of the rows are considered common and do not match." ----- Original Message ----- From: "Taco Fleur" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, June 21, 2006 12:21 AM Subject: Full-Text problems > Hi all, > > I am experiencing some issues with Full-Text and was hoping someone could > shed some light on the following. > > I have some content which I know contains for example the word "news", the > table is MyISAM, the column type is LONGTEXT, there is an index on the > column of FULLTEXT. > > I have adjusted the system variables so that the minimum word length is 2 > (ft_min_word_len = 2) and the stop word file is set to (ft_stopword_file = > '') > > Can anyone tell me why it is not picking up the word news plus some others? > > I have verified that the system picked up the new variable settings with > SHOW VARIABLES > > I have also deleted everything in that table and reinserted the content, > which I hope rebuilds the table? > > Other words that do not appear are; > - dealer > - sign in > - contact > > I have verified that it returns other results, i.e. when searching on words > like; > - headline > - engineering > - user > - her > > The query is as below > > SELECT I.indexIdentity > , I.webpageIdentity > , I.content > , I.indexDate > , MATCH ( I.content ) AGAINST ( '#form.searchString#' ) AS score > , W.universalResourceLocator > , W.title > FROM tbl_index I > INNER JOIN tbl_webpage W > ON I.webpageIdentity = W.webpageIdentity > WHERE MATCH ( I.content ) AGAINST ( '#form.searchString#' ) > ORDER BY score DESC; > > The content is text I gathered from our webpages, I am basically trying to > create a site search. > Any help is much appreciated. > > Kind regards, > > > Taco Fleur > > Free Call 1800 032 982 or Mobile 0421 851 786 > Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an > industry leader with commercial IT experience since 1994 . > > * > > Web Design and Development > * > > Accept online Credit Card payments www.commerceengine.com.au > <http://www.commerceengine.com.au/> > * > > SMS Solutions, including developer API > * > > Domain Registration, .COM for as low as fifteen dollars a year, > .COM.AU for fifty dollars two years! > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]