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:brenttech@stripped]
Sent: Wednesday, 21 June 2006 10:24 PM
To: taco.fleur@stripped; mysql@stripped
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" <taco.fleur@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
