Pieter,
I think FTS minimum WORD size is 4 characters - you may to be searching
with 3 on 'May May'.
Not having ever used FTS; I believe you can adjust it to count 3-character
words by changing the configuration, but I'm not sure where - and it would
then need re-indexing, if I'm not mistaken.
Hope that helps
Terry
----------Original Message---------
> 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]
