My previous post compared MySQL and ferret full text search engines. For our project, the ferret was the winner. Nevertheless, I will try to show the beauty and simplicity of using MySQL indexes. Create table and indices First of all it is necessary to create table and the corresponding index. Create table articles( id integer not null primary key auto_increment, title varchar(20), body varchar(10