I think you need to do this:
ALTER TABLE table1 ADD FULLTEXT (column1)
I may be wrong though, and I too have a question.
Does adding the FULLTEXT index affect performance dramatically? If it does,
what is a better way to search for exact word matches in columns that may
contain thousands of wo
On Wed, 2002-01-16 at 18:51, [EMAIL PROTECTED] wrote:
> Hi there.
>
>
> I need to do this sentence:
> select * from table1 where match column1 against "word";
Try:
select * from table1 where match column1 against ("word");
> But it don´t works becouse crate the column like this:
> alter table
Hi there.
I need to do this sentence:
select * from table1 where match column1 against "word";
But it don´t works becouse crate the column like this:
alter table table1 add column1 varchar(100);
Well my question is:
How I should create the column1 to have fulltext for this query??
Thanks
Vict