1

2

3

4

5

6

create table goods(

    id integer primary key auto_increment,

    name varchar(255) comment '名称',

    description text comment '描述',

    FULLTEXT idx(description)

) comment '商品';

1

select TABLE_ID, NAME, SPACE from information_schema.INNODB_TABLES where NAME like 'study/%';

1

INSERT INTO study.goods (name, description) VALUES ('兰蔻塑颜紧致百肽面霜', '兰蔻塑颜紧致百肽面霜75ml保湿护肤品套装 礼盒生日礼物送女友送妈妈')

1

select * from goods where match(description) against('礼盒生日礼物送女友送妈妈');

1

select * from goods where match(description) against('礼盒生日礼物');