MySQL Forums
Forum List  »  Full-Text Search

Strange with some word
Posted by: Vincenzo Ingrosso
Date: May 19, 2007 05:37AM

My fulltext serach work fine to 99%...

My problem, when I search for words like 'bin', 'gcc' fulltext search works very fine...but if I search for specific word 'etc' I received an empty result.

Is it a my problem...or it's a server problem?!

SOME DETAILS:

Server version: 5.0.37
MySQL charset: UTF-8 Unicode (utf8)
Table type : MyISAM
Table Collation : latin1_swedish_ci

My Query :

SELECT name, dir, location, descr, MATCH (`name`, `descr`)
AGAINST ('etc') AS score FROM packages WHERE
MATCH (`name`,`descr`) AGAINST
('etc' IN BOOLEAN MODE) AND `ver_name`='$version'
ORDER BY score DESC LIMIT 0,20


Thank you for the help...

P.S: sorry for my bad english! ;^)



Edited 1 time(s). Last edit at 05/19/2007 05:40AM by Vincenzo Ingrosso.

Options: ReplyQuote


Subject
Views
Written By
Posted
Strange with some word
3484
May 19, 2007 05:37AM
2466
May 20, 2007 03:43PM
2309
May 21, 2007 01:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.