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 words in each entry? LIKE doesn't do it properly. It will find 'then Richard said to' when I search for Rich and I don't want that.. Thanks, Rich Foreman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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 Victor. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
