A full-text index is a special type of index optimized to search through the text-based columns. They can only be created for columns of the type CHAR
, VARCHAR
, and TEXT
.
Import the ISFDB database as described in the Importing the data exported by mysqldump recipe from Chapter 2, Diving Deep into MariaDB.
Launch the
mysql
command-line client application and connect to theisfdb
database on our MariaDB server.Create a
FULLTEXT
index on thenote_note
column of thenotes
table using the following command:CREATE FULLTEXT INDEX note ON notes(note_note);
When MariaDB has finished creating the index, we will get an output similar to the following:
Query OK, 246719 rows affected (11.08 sec) Records: 246719 Duplicates: 0 Warnings: 0
Show the indexes on the
notes
table with the following command:SHOW INDEX FROM notes\G
The output of the
SHOW
command will look like the following screenshot: