FULLTEXT INDEX

FULLTEXT INDEX is a SQL statement in the Indexes category. Special index for full-text search queries (MATCH ... AGAINST). Supported in MySQL, PostgreSQL. The syntax is CREATE FULLTEXT INDEX index_name ON table_name (column);. It returns full-text index. A typical example: CREATE FULLTEXT INDEX ft_articles ON articles (title, body); -- Then use for text search: SELECT * FROM articles WHERE MATCH(title, body) AGAINST('database optimization' IN NATURAL LANGUAGE MODE); A close relative is CREATE INDEX, which creates an index on one or more columns to speed up query performance. A close relative is DROP INDEX, which removes an existing index from a table. A close relative is COMPOSITE INDEX, which an index on multiple columns. Column order matters — queries use leftmost prefix. More about this category: Database indexes — CREATE INDEX, UNIQUE INDEX, COMPOSITE INDEX, DROP INDEX. Related Indexes entries: CREATE INDEX, DROP INDEX, COMPOSITE INDEX, EXPLAIN, SPATIAL INDEX, INCLUDE INDEX (Covering Index), PARTIAL INDEX, INVISIBLE INDEX.