我有如下语句
select count(*) from search where match(tissue,disease,cell_line,other_name) against ('+breast+cancer' IN BOOLEAN MODE) ;
返回726行数据
但是将语句改为
select count(*) from search where match(disease) against ('+breast+cancer' IN BOOLEAN MODE) ;
返回变为94
后面查了下第一个语句disease字段里包含Breast_cancer_high-risk_for_distant_metastasis,但是在第二个语句的disease字段中只有Breast cancer
不知道语句哪里有问题啊?