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