Fulltext search is based on relevance. If the words you're searching for appear in over 50% of the rows, MySQL assumes they aren't relevant because they occur too often. Try inserting more rows with different info in the fields that have the fulltext index -- then try your search again.
--jeff ----- Original Message ----- From: "Jan Peuker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 10:24 AM Subject: FullText Search 3.23.49-nt > Good evening List, > > I have a problem on my fulltext-search. If I create the sample table from > MySQL-Doc it runs perfect. > If I create my own - it doesn't. I can't say more: Here is my dump: > > CREATE TABLE tcl (id int(10) primary key not null, description varchar(254), > date timestamp, value int(11), department tinyint(3), text text, > fulltext(description,text)) > > If I take a look on my table stucture (using phpmyadmin or describe) it > seems ok. > > Now I do some inserts like this: > > INSERT INTO tcl VALUES(1,'dummy',,0,1,'lorem ipsum lorem ipsum'); > > If I take a look again it look harmless. > > Now I do this > SELECT * FROM tcl() WHERE MATCH(description,text) AGAINST('ipsum') > or > SELECT tcl.'text' FROM tcl() WHERE MATCH(text) AGAINST('ipsum') > > And nothing happes, this means, it retuns 0 rows. > Any suggestions? > > Jan > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php