We're having quite a lot of difficulty with MySQL's fulltext search. The
problem is that it does partial matches. E.g., john matches johnson. Thus
a match of author against dickens takes about 0.09 seconds with a 700,000
record table, but a match of a shorter word takes a good deal longer - a
four
--- Colin Faber <[EMAIL PROTECTED]> wrote:
> Ok,
>
> The message set that I noticed this morning sparked my interest in this.
>
> Currently I'm developing a search engine that will utilize mysql's
> fulltext match technology. The problem that i've run into is, I can't
> seem to find any docu
--- Stoyan <[EMAIL PROTECTED]> wrote: > hi,
>
> why don't you try to use this:
>
> SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%';
That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles')
and match author against('dickens')) takes 1.3 seconds. Fulltext searching
is MU
Hi. Our clients are asking for AND searches in fulltext fields. The manual
says it's already implemented in the 4.0 tree. Can anyone tell me when we
will see a public version of MySQL featuring AND searches in fulltext fields?
=
D
> Hi. Can anyone tell me how this [viz. compiling MySql on Windows] is
done? There doesn't seem to be any
> documentation on how to do this under Windows, and when I tried running
> the make_all batch file, it didn't seem to work with my version of
> nmake.
>
> Does anyone have any guidance - wha