Hi!
On Oct 19, Jeroen Geusebroek wrote:
> Hi there,
>
> I'm trying to use fulltext for speeding up my queries, but i found some
> strange
> difference in the results between fulltext & Like ; for example:
>
> AGAINST('+shed +some +light +on +this')
>
> gives less matches then:
>
> AND field LIKE '%shed%' AND field LIKE '%some%' AND field LIKE '%light%'
> AND field LIKE '%on%' AND field LIKE '%this%'
>
> The query itself is 10 times faster when I use fulltext. So I would
> really like to use that ;)
>
May be because your LIKE query finds also
'something will not shed any light on this!!!'
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
