Hi!
On Oct 13, Alan wrote:
>
> mysql> select title from content where match
> (title,center_content,right_content) against ('updates');
> +-----------------------------+
> | title |
> +-----------------------------+
> | eXI Systems' Latest Updates |
> +-----------------------------+
> 1 row in set (0.00 sec)
>
> But when I try to match on 'exi', I get:
>
> mysql> select title from content where match
> (title,center_content,right_content) against ('exi');
> Empty set (0.00 sec)
Try MATCH ... AGAINST (... IN BOOLEAN MODE).
If it'll work - it means that the word is present in more than 50% of
rows. See the manual about 50% threshold.
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
