Creating FULLTEXT KEY

[NevadaSam]

When I CREATEd the table this is how I set up the indexes. When ever the database is searched, I want the search to include all the data in both column. How should I set it up to search both columns?

 

  FULLTEXT KEY `col1` (`col1`),
  FULLTEXT KEY `col2` (`col2`)

 

Sam

;

[bubblegum.anarchy]

Probably the following:

 

ALTER TABLE table
     AND FULLTEXT FT_DESCRIPTION (column1, column2);