/*table create*/

CREATE TABLE users (
 id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
 title varchar(100) NOT NULL,
 author varchar(100) NOT NULL,
 edition int(2) NOT NULL,
 isbn varchar(13) NOT NULL,
 price decimal(4,0) NOT NULL,
);

/*fulltext index*/

ALTER TABLE booklist ADD FULLTEXT(title, author);

/*match query*/

SELECT * FROM booklist WHERE MATCH(title) AGAINST ('test');