RE: [PHP] FULLTEXT ALTER Needed

It works with two alters, I couldn't get it to work with one - ALTER TABLE table ADD newcol TEXT; ALTER TABLE table FULLTEXT(newcol); Also, you might want to try the MySQL mailinglist. You will also need a VERY recent MySQL version, 3.23.23 or higher. > -----Original Message----- > From: Don Smith [mailto:don@newsvideo.com] > Sent: 10 September 2000 20:31 > To: php-general@lists.php.net > Subject: [PHP] FULLTEXT ALTER Needed > > > 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 >