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
