Funny results using Match Against

[Jason White]

I used this statement to create a table annotation.

create table annotation
(
user_id int not null NOT NULL,
oai_id varchar(255) NOT NULL,
element varchar(255),
value text,
datestamp varchar(10),
status enum("A", "I"),
fulltext(value)
);

I then insterted so test data into the table so that it contains these records.

user_id oai_id element value datestamp status 1 oai:tower:TowerMemorabilia_m_218_6 description the database sucks 2002-10-30 A
1 oai:tower:TowerMemorabilia_m_176 description this is a test 2002-10-30 A
1 oai:tower:TowerMemorabilia_m_178 description What is going on 2002-10-30 A
1 oai:tower:TowerMemorabilia_m_180 description this is a test the database sucks 2002-10-30 A

I then executed the query

select oai_id, value, match (value) against ('database') from annotation

This returned some match values > 0, however after I editted a few records I ran the query again and did not get any match results > 0. I did not remove the term database from any of the records and therefore expected some positive results. In preparing this message I inserted a new record in the table and ran the query a 3rd time. I am now see positive match results for the expected records.

It appears that updating any record in a table causes problems. Is there something I can do to reindex the table and correct this?

Thanks,

Jason White
Emory University General Libraries.










---------------------------------------------------------------------
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