?????????????????????????MySQL????????????????
????1??MySQL???????????????????
????2?????????????
????3?????????????????
????4??????????????????
???????????????????????
????· ???????????????fulltext???????????match????????б?????fulltext???????
????· ???????????????MyIsam???????У?MySQL 5.6????????????Innodb???????????
????· ??????char??varchar??text??????????洴?????????
????· ????????????????????????????????????????????????????
????· ???????????????????????????????????в????????????????????????????????в????????????
????· ?????????????????????????????????????????
????· ???????????????????50%???????????????????????????????
?????????????????
????MATCH (????1?? ????2??…) AGAINST (????????? [???????η?])
??????????match?????????????1??2?????????????????????????????? ????????????η???????￡?
????search_modifier:
????{
????IN NATURAL LANGUAGE MODE
????| IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
????| IN BOOLEAN MODE
????| WITH QUERY EXPANSION
????}
???????????????????
????????????????η?????????????3?????????????
????IN NATURAL LANGUAGE MODE
??????飺??????????????????κ????????η????????η?? IN NATURAL LANGUAGE MODE ???????
???????
????1????????????????е?????????????????????????????????
????2????????????б??е?????????й???
????3?????????????????50%???????????????????
????4???????????????????????????????
????IN BOOLEAN MODE
??????飺???????????????????η??IN BOOLEAN MODE???????
???????
????1???????????????????????????е????????????壬?????Щ????????????磺??????????????????????????
????2??????????????????????????????????????????
????WITH QUERY EXPANSION
??????飺????????????????????????????????2??????????????????????????????????????δ?IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION ????WITH QUERY EXPANSION modifier
????????????????????????????????????????????????磺????????????????????????????????????????е??????????????????????????????????????е??????????????????Щ??????????????
????????????????????????
????IN NATURAL LANGUAGE MODE???μ?????
?????????????product?????????name???????????????????????????????????????name???????????
????Sql??????￡?
????SELECT * FROM product WHERE match(name) against(‘auto’)
??????仹??????????87w????????????1w?????????1.15??Ч?????????
???????????????????????????????????????????
???????????SELECT match(name) against(‘auto’) FROM product ????????????????????0??1??? 0???????????