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