Create a fulltext index

See Also

1. Open the table in Design View

2. Select the Index tab

3. To add a new index definition, select Add from the Index menu

4. In the Name column enter the name of the index

5. In the Field Name column select a field for the index

6. Select Full Text from the Index Type combo box

7. Select Save… or Save As… from the File menu when you are ready to save the table

Note: Fulltext indexes can only be defined on TEXT and VARCHAR fields in tables of type MyISAM.