Add Full Text; *OOOOPS!!!*

[Davidc316]

Hi ho,

I have created a database table which has the ability to do full text searches within two columns called 'title' and 'body'.

I created the full text thingy by using the following MySQL command...

ADD FULLTEXT(body, title);

The trouble is, I've had some time to think and I now realise that I have made a serious blunder. I wanted to have the full text searches applicable to the column called 'description' also. So my full text command (when I was creating the table) should have been....

ADD FULLTEXT(body, title, description);

But, it's too late to turn the clocks back and do that. So, I'm just wondering if I have ruined my table or is there any way to extend the full text thingy to include the description column.

Thanks.

[stolzyboy]

ALTER TABLE tablename ADD FULLTEXT (columnname)

[Davidc316]

I tried that and now I get the following error...

"Can't find FULLTEXT index matching the column list"

I have now deleted my entire table and I'm in the process of trying to rebuild it. I'm sure I'll get there in the end but it's not much fun.

Thanks!