Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //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');
Add Comment
Please, Sign In to add comment