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 ;)
You would think it would give the same results right? I have configured
MySQL to not index word less then 2 characters,
instead of the standard 4 characters. The fulltext index is up-to-date.
What could be the problem?
Thanks,
Jeroen
---------------------------------------------------------------------
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
