I havent changed these settings but there is a section on it
in the mysql manual. And yes mysql filters everything under
4 letters out and it wont output results for words matched too
often (I think the manual said more than 50% but it was only
for words that matched all entries for me).
From the manual:
Minimal length of word to be indexed is defined in myisam/ftdefs.h file by
the line
#define MIN_WORD_LEN 4
Cheers, Nessi
At 17:09 19/06/01 , you wrote:
>Hi. We're using full text searches to search a database of books.
>
>In the absence of AND searches, promised for MySQL v4 (e.g., "+joe
>+johnson"), we're doing splitting and doing multiple full text matches.
>
>For example, charles dickens to find all books matching charles dickens,
>the query is done WHERE MATCH author AGAINST('charles') AND MATCH author
>against('dickens').
>
>Unfortunately, for words shorter than four letters the query is ignored
>(presumably because it is assumed that it would return a lot of results),
>so a search for Ian Fleming returns zero results.
>
>Can anyone suggest how to make this work properly?
>
>=====
>
>
>____________________________________________________________
>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
