With so few rows, are you hitting the 50% rule? Try again with a decent
number of rows.
> -Original Message-
> From: devy [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 04, 2007 5:46 AM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Fulltext problem
>
> Hi,
> today I've
Hi Devy --
There are a couple of issues with your query below, and hopefully we can help
you figure it out.
First off, your table and query structure are fine. However, one can ask why
not use a TINYTEXT or even a TEXT field instead of VARCHAR(255). It's all in
the memory overhead. =)
Moving
devy wrote:
---cut---
-
insert into ft_test (field1,field2,field3)
VALUES('mysql full text', 'this is a test', 'mysql fulltext');
-
the problem is that when I execute this query I always get 0 as
relevance:
---cut---
A FULLTEXT search will not match return val
Hi!
On Aug 15, Martin Kjeldsen wrote:
> Hi,
>
> if you use the fulltext to search for words like "internet.com" my
> search allways fails. The reason for is as far as I know that the
> dot (".") is used by the parser as a word separator at least when
> making the index.
>
> The easy way to sol
Off the top of me balding head I can think of two things...
One is just leave the dot out and add it in later. Just look for com or couk
netetc
I also know there is a way of telling SQL that . it a char by putting it in
some kind of "" but I can not remember how
I hope this helps a bit..
