CREATE TABLE testtable ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, textfield varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci, FULLTEXT (textfield) ) ENGINE=MyISAM; Insert into testtable (textfield) values ('one word'),('two word'),('three word');