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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Cc: "'Brent Baisley'" <[EMAIL PROTECTED]>
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:[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]
