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); 11INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp'); 12INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj'); 13INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb'); 14SELECT a, round(MATCH b AGAINST ('lala lkjh'),5) FROM t1; 15a round(MATCH b AGAINST ('lala lkjh'),5) 161 0.67003 172 0.00000 183 0.00000 19SELECT a, round(MATCH c AGAINST ('lala lkjh'),5) FROM t1; 20a round(MATCH c AGAINST ('lala lkjh'),5) 211 0.00000 222 0.67756 233 0.00000 24SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1; 25a round(MATCH b,c AGAINST ('lala lkjh'),5) 261 0.64841 272 0.66266 283 0.00000 29drop table t1; 30