It's not necessarily the word appearing in more than 50% of thre records. If you search
result returns more than 50% of the records,
mysql considers the result irrlevant and doesn't return anything.
You can kind of test it by using LIKE.
SELECT count(*) from table where field like "%dealer%" or field like "%contact%"
Remember, by default full text will find records that contain any of the words you are
searching on. If you want to find only
records that contain all the words, you need to do full text boolean search.
----- Original Message -----
From: "Taco Fleur" <taco.fleur@stripped>
To: <mysql@stripped>
Cc: "'Brent Baisley'" <brenttech@stripped>
Sent: Wednesday, June 21, 2006 8:51 AM
Subject: RE: Full-Text problems
> 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
>
>
>
