Good morning. Not knowing too much about PHP it looks like you are
searching for
`name`,`colour`,`gender`,`breed`,`location`,`description`
Where there is a whitespace in the name.
Could you use,
$query_results = sprintf("SELECT * FROM dogslost WHERE
`name` LIKE '% %'", $crit_results);
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-----Original Message-----
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 5:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Full text search problem
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
