| 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 questions | Clemson Chan | 6 Sep |
| • RE: FULLTEXT search questions | Clemson Chan | 7 Sep |
| • RE: FULLTEXT search questions | Peter Lovatt | 7 Sep |
| • RE: FULLTEXT search questions | Clemson Chan | 7 Sep |
