Hi!

On Apr 15, Nicholas Murphy wrote:
> 
> The query
> 
> select * from tablename where match(column_name)
> against('three'); 
> 
> fails to match any record.
> 
> Ten to twelve records in the table are know to have 
> the distinct word "three" in them in the indexed column.
> 
> Question:
> 
> Is this in any way expected behavior?

Yes.
-----
% grep three myisam/ft_static.c
  "three",
%
-----
That is "three" is present in the stopword list.
Of course, you can remove it from there and rebuild MySQL
(and your indexes).

Regards,
Sergei

-- 
MySQL Development Team
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/

---------------------------------------------------------------------
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

Reply via email to