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
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. =)
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
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...