Hi Pieter,
That's because "may" is a stopword in MySQL's full-text indexing, by
default (like "can," "the," etc). You can define your own stopword file
with the ft_stopword_file variable. And you can find the default, built-in
list of stopwords in the file myisam/ft_static.c of the source
distribution.
Hope that helps.
(Oh, also what Terry said in his reply!)
Matt
----- Original Message -----
From: "Pieter Botha"
Sent: Monday, June 21, 2004 3:54 AM
Subject: Full text search problem
> Hi
>
> I have a fulltext search on a dbase for lost pets.
> My problem is the following:
>
> I have dog in the database called "May May" which doesnt show up in the
> search results. A dog called "Doggy Doggy" does show up however. I guess
> the problem is that MySql sees "May May" as being a date or something
> and doesnt do a text compare.
>
> Here is my query, from php.
> $query_results = sprintf("SELECT * FROM dogslost WHERE MATCH
> (`name`,`colour`,`gender`,`breed`,`location`,`description`) AGAINST
> ('%s' IN BOOLEAN MODE)", $crit_results);
>
> any ideas?
>
> Regards
> Pieter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
