Hi!
On Aug 28, Alok K. Dhir wrote:
>
> > select * from Laws WHERE MATCH(Line) AGAINST ('growth
> > hormone') AND Line like '%growth hormone%' ORDER BY ID;
>
> This defeats the purpose of the fulltext index, don't you think?
>
> Al
Not really, as fulltext index is used to find the documents that contain
either "growth" or "hormone", and LIKE is applied only to those documents,
not to all the rows.
But, indeed, this is a hack and at some point - not in 4.0 though,
MySQL will have support for phrase searches.
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
