1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1 ( 3a int(11) NOT NULL auto_increment, 4b text, 5c varchar(254) default NULL, 6PRIMARY KEY (a), 7FULLTEXT KEY bb(b), 8FULLTEXT KEY cc(c), 9FULLTEXT KEY a(b,c) 10) ENGINE = InnoDB; 11drop table t1; 12CREATE TABLE t1 ( 13a int(11) NOT NULL auto_increment, 14b text, 15c varchar(254) default NULL, 16PRIMARY KEY (a), 17FULLTEXT KEY a(b,c) 18) ENGINE = InnoDB; 19INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp'); 20INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj'); 21INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb'); 22ANALYZE TABLE t1; 23SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1; 24a round(MATCH b,c AGAINST ('lala lkjh'),5) 251 0.22764 262 0.22764 273 0.00000 28SELECT a, round(MATCH c,c AGAINST ('lala lkjh'),5) FROM t1; 29a round(MATCH c,c AGAINST ('lala lkjh'),5) 301 0.22764 312 0.22764 323 0.00000 33SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1; 34a round(MATCH b,c AGAINST ('lala lkjh'),5) 351 0.22764 362 0.22764 373 0.00000 38drop table t1; 39