MySQL8.0全文本搜索案例（布尔文本搜索、使用扩展查询）

## 建表语句

drop table if exists product_notes;

create table product_notes (

note_id int not null AUTO_INCREMENT,

prod_id varchar(100) not null,

note_text text,

primary key(note_id),

FULLTEXT(note_text)

) ENGINE = MyISAM;

## 插入数据

insert into product_notes (prod_id,note_text)

values

('0001','I am so gladful that I receive this fiction book so soon, the logistics is really quickful,and it is a useful fiction book,I am so happy, and also the packaging is very good, lol'),

('0002','the book is very useful，looks very cool!'),

('0003','The packaging looks amazingly beautiful, it is so cool!'),

('0004','Hey boss, I will come again someday!'),

('0005','fiction book is so cheap, cool!'),

('0006','I admire the author since long time ago, hope that I could finish