Re: intersting bug with full text match against

[Jeremy Zawodny]

On Thu, May 29, 2003 at 01:23:08PM +1000, Daniel Rossi wrote:
>
> i am getting people to try and break a search engine i built , when
> we put in the word DB into the search query i get no results even if
> its there in the record , why is this ?
> 
> WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN
> BOOLEAN MODE) LIMIT 0 , 10 ;

Because you haven't told MySQL to index 2 character words.

  http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 114 days, processed 3,575,496,646 queries (360/sec. avg)