MySQL全文搜索

/*************by Jiangong SUN********************/

 

create database testDB:use testDB; create table testTable(pk_tId int auto_increment not null,firstName varchar(20),lastName varchar(20),age int,details text,primary key(pk_tId),unique id(pk_tId),fulltext(firstName, lastName, details)); insert into testTable values(0, 'Mitchell', 'Harper', 20, 'Mitchell is the founder and manager of devArticles and various other sites across the SiteCubed network');insert into testTable values(1, 'Ben', 'Rowe', 19, 'Ben is our Flash guru. He is currently writing a series of Flash articles that show beginners how to use Flash to create dynamic content with PHP');insert into testTable values(2, 'Havard', 'Lindset', 19, 'Havard is a PHP and MySQL power user');insert into testTable values(3, 'Michael', 'Manatissian', 25, 'Michael is the senior devArticles editor and is a capable Linux/Apache administrator');insert into testTable values(4, 'Sandra', 'Lee', 23, 'Sandra is our finance and accounting wizard, having 4 years of experience under her belt');SELECT *FROM testtableWHERE MATCH (firstName, lastName, details)AGAINST ('founder');