--- 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
--- 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
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
> 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
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