Re: FULLTEXT ALTER Needed

as the mysql manual says: http://www.mysql.com/documentation/mysql/commented/manual.php?section=ALTER_TABLE ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...] alter_specification: ADD [COLUMN] create_definition [FIRST | AFTER column_name ] or ADD [COLUMN] (create_definition, create_definition,...) or ADD INDEX [index_name] (index_col_name,...) or ADD PRIMARY KEY (index_col_name,...) or ADD UNIQUE [index_name] (index_col_name,...) or ADD FULLTEXT [index_name] (index_col_name,...) or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT} or CHANGE [COLUMN] old_col_name create_definition or MODIFY [COLUMN] create_definition or DROP [COLUMN] col_name or DROP PRIMARY KEY or DROP INDEX index_name or RENAME [TO] new_tbl_name or table_options ALTER TABLE crews ADD FULLTEXT idx_category (category); Don Smith wrote: > > Boy, I'm THIS CLOSE to finding the answer in my textbooks, but none quite go > the distance. > > I have a text blob column that I need indexed so I can perform SELECT's with > pattern matching within the text. I'm told on one site that I can index a > text blob with FULLTEXT(columnname) with an ALTER command, but no example is > given. I need to alter a table called 'crews' and fulltext index the column > 'category' > > The closest I can come from examples is: > alter table crews add cat fulltext(category); > > Clearly, that's wrong. I'm attempting to create a new column named 'cat' > that is a fulltext index of category. > > Thanks, > Don Smith > mailto:don@newsvideo.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Monte Ohrt <monte@ispi.net> http://www.ispi.net/