MariaDb Essentials

Working with full-text indexes

In order to perform full-text searches on a table, you must index the data. In MariaDB, the type of index used for full-text searches is named FULLTEXT.

A full-text index can only be created on a column of type CHAR, VARCHAR, or TEXT.

As with the other indexes, the FULLTEXT index can be created by using CREATE TABLE when creating a new table, or by using ALTER TABLE or CREATE INDEX on an already existing table.

The following code will create a table, posts, with a full-text index on the content column:

CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text,
  PRIMARY KEY (`id`),
  FULLTEXT (`content`)
) ENGINE=InnoDB;

If you already have a table without a full-text ...