create table t1 (i int, f1 varchar(512), f2 varchar(512), fulltext (f1)) engine=myisam partition by hash (i); select * from t1 where match (f1) against ('foo'); i f1 f2 select * from t1 where match (f2) against ('bar' in boolean mode) ; i f1 f2 drop table t1;