On Sun, Oct 13, 2002 at 10:58:53PM +0000, Sergei Golubchik wrote:
> 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.
Ah, it all makes sense now! Looks like my simple example search was
fubar due to the 50% thing :\ Mucho thanks!
--
Alan "Arcterex" <[EMAIL PROTECTED]> -=][=- http://arcterex.net
"I used to herd dairy cows. Now I herd lusers. Apart from the isolation, I
think I preferred the cows. They were better conversation, easier to milk, and
if they annoyed me enough, I could shoot them and eat them." -Rodger Donaldson
---------------------------------------------------------------------
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
