Hi all,

I have table called 'profile' i have altered the table

ALTER TABLE profile ADD FULLTEXT ( oname , etc...);

I have 14 cols in the alter list - (oname, etc..)

This creates an index that appears to be empty.
My dbase has 1800 rows the cardinality says none.
I'm using MySQL 3.23.56

Any ideas where I may be goin wrong?

If I can get this working will I have to reapply the process each time a change happens manually or does it update automatically?

Thanks in advance

Chris