Alter table to add a fulltext index : Index « FullText Search « SQL / MySQL






  1. SQL / MySQL
  2. FullText Search
  3. Index

Alter table to add a fulltext index

    

ALTER TABLE tblname ADD FULLTEXT [indexname] (indexcols ...)








Related examples in the same category

1.Performing Phrase Searches with a FULLTEXT Index
2.FULLTEXT search index
3.Create a fulltext index on the combination of TITLE and SUMMARY.
4.Using fulltext index
5.Creating a Full-Text Index