Add column to a pre-existing fulltext index?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jraede
Forum Contributor
Posts: 254
Joined: Tue Feb 16, 2010 5:39 pm

Add column to a pre-existing fulltext index?

Post by jraede »

What's the syntax for that?
User avatar
emmbec
Forum Contributor
Posts: 112
Joined: Thu Sep 21, 2006 12:19 pm
Location: Queretaro, Mexico

Re: Add column to a pre-existing fulltext index?

Post by emmbec »

can you explain more? What are you trying to do?
jraede
Forum Contributor
Posts: 254
Joined: Tue Feb 16, 2010 5:39 pm

Re: Add column to a pre-existing fulltext index?

Post by jraede »

I have a full text index on the "title" column of a table, but I want the end user to be able to choose whether or not to include the "description" column in that index. Right now I'm just dropping the index and recreating it, but I was wondering if there's a way to update it by adding or removing the description column without dropping it and recreating.
Post Reply