List:General Discussion« Previous MessageNext Message »
From:Clemson Chan Date:September 6 2002 7:05pm
Subject:FULLTEXT search questions
View as plain text  
Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.

The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be
created?

In my table, the 'body' column was define as BLOB, should I change it TEXT
before add the new FULLTEXT column? And what is the best to ALTER the column
from BLOB to TEXT without messing up the data.

Thanks a lot,

--Clemson

Thread
FULLTEXT search questionsClemson Chan6 Sep
  • RE: FULLTEXT search questionsClemson Chan7 Sep
    • RE: FULLTEXT search questionsPeter Lovatt7 Sep
    • RE: FULLTEXT search questionsClemson Chan7 Sep