mysql全文索引基础语句_Mysql全文索引技术测试语句序列

CREATE TABLE `test`.`IndexTest` (

`pr` INTEGER UNSIGNED NOT NULL,

`t1` VARCHAR(45) NOT NULL,

`t2` VARCHAR(45) NOT NULL,

PRIMARY KEY (`pr`)

)

ENGINE = MyISAM;

insert into IndexTest(pr, t1, t2) values(1, 'jack yy barclay', 'time date value interesting');

insert into IndexTest(pr, t1, t2) values(2, 'mary yy user', 'here there date');

insert into IndexTest(pr, t1, t2) values(3, 'john jack mary', 'value newyork');

select * from IndexTest where match(t2) against('date' IN BOOLEAN MODE) limit 100;select * from IndexTest where match(t1,t2) against('jack' IN BOOLEAN MODE) limit 100;select * from IndexTest where match(t1,t2) against('yy' IN BOOLEAN MODE) limit 100;