Fulltext search is based on relevance. If the words you're searching for
appear in over 50% of the rows, MySQL assumes they aren't relevant because
they occur too often. Try inserting more rows with different info in the
fields that have the fulltext index -- then try your search again.
--jeff
-
> Try not using the word 'text' as your column name. Using reserved and key
> words causes problems.
> Chris
sql
> >>CREATE TABLE tcl (id int(10) primary key not null, description
> varchar(254), date timestamp, value int(11), department tinyint(3), text
> text, fulltext(description,tex