Re: More questions about Fulltext searching.
--- 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 MUCH more efficient.
=
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: More questions about Fulltext searching.
--- 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 documentation on how to force an AND search with in
MATCH AGAINST syntax, As far as I can tell this is `OR' only. Has is
there
an option to force AND?
Sadly not. I've had the same trouble as you with this. It's mentioned
somewhere
(http://www.mysql.com/doc/F/u/Fulltext_Features_to_Appear_in_MySQL_4.0.html)
that this will be in v4; until then, no chance.
The way I do this is to split queries into words and do AND.
So to find charles dickens:
SELECT * FROM BOOK WHERE MATCH author AGAINST ('charles') AND MATCH author
AGAINST ('dickens')
If anyone knows how to make 'charles dickens' match simply fields
containing both those words, rather than one or the other (ordering by
score helps, but still the last results would be irrelevant), please
enlighten me.
=
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Full text search gotchas
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-letter word takes several seconds. Does anyone know whether it's possible to change this so substring matches (such as john against johnson) are NOT made? (Perhaps someone has a patch or a suggestion as to how to make this work.) Also, having incidentally changed ftdefs.h to match 3-letter words, is it now necessary to rebuild the fulltext indexes? = Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling MySQL under Windows
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 - what sofware do I need? [I have Visual Studio 6.] = Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4
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? = Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
