NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL full text search

Hans Zaunere lists at zaunere.com
Thu Feb 17 20:25:05 EST 2005


>   I applied a full text index to a table.
> 
> Had one entry in the DB and the match function didn't work. I figured
> the database need more entries to actually create the index.
> I created five more entries and the searches worked, but when I have a
> search term which is present in more than four rows, I seem to be
> getting an empty set.

There are a series of search word length, frequency, etc. constraints that can be applied.  Take a look at http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html

H






More information about the talk mailing list