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]