Just a small comment to this thread:
If you follow this link you'll see that you are searching on two words which
both are only two chars long.
Just press the 'søk' bottom and you will be doing a search on the
booktitles, in a database containing 1.4mill books, running Mysql
4.0.4-beta.
I dropped
I've actually just started playing with full text indexes and have been
following this thread along with searching the internet. I'm not using
MySQL 4 yet, so my options are limited. I do have a need to search on
three letter words (i.e. C++,ASP,AIX,awk, XML).
What I am doing now, which seems to
Kevin,
are you sure that your 2 and 3 letter words do not appear in more than
half of all rows? That would exclude them from the search.
Thomas
On Wed, 20 Nov 2002, Kevin Lewandowski wrote:
> Hi, Sergei.
>
> In myisam/ftdefs.h I changed:
>
> #define MIN_WORK_LEN 4
>
> to:
>
> #define MIN_WORD_L
Hi, Sergei.
In myisam/ftdefs.h I changed:
#define MIN_WORK_LEN 4
to:
#define MIN_WORD_LEN 2
and I commented out the line:
#define COMPILE_STOPWORDS_IN
(this should leave out stopwords right?)
There were no changes to ftstatic.c
recompile, reinstall, restart mysql.
To test I dropped and rec
Hi!
On Nov 18, Kevin Lewandowski wrote:
> I'm using mysql fulltext indexes and want them to see words of 2 or
> more characters, and no stopwords. I've edited the appropriate files
> (ftdefs.h, ft_static.c), then recompile, install, restart mysql,
> rebuild indexes, and there is no change. It s
I thought that option was only available on version 4.0 and above? I'm
using 3.23.52-max.
thanks
On Tuesday, November 19, 2002, at 07:22 AM, Thomas Spahni wrote:
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters,
At 16:22 +0100 11/19/02, Thomas Spahni wrote:
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart mysql,
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
> I'm using mysql fulltext indexes and want them to see words of 2 or
> more characters, and no stopwords. I've edited the appropriate files
> (ftdefs.h, ft_static.c), then recompile, install, restart mysql,
> rebuild indexes, and there is no change. I
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart mysql,
rebuild indexes, and there is no change. It still uses a minimum of 4
characters). I'm using
